Form question...

[qmp]

I'm makeing a progarm useing the form input. I have a button on the page that I want to use to open the form page. How do I make the button open up the input intead of clicking on the toolbar>data>form... as a short cut?

Thanks...

 

[DominicB]

Good evening qmp

Use this simple macro assigned to your button :

Sub test()
ActiveSheet.ShowDataForm
End Sub

To assign to a button, enter this code, then (I assume you drew your button from the Forms toolbar?) right click and select assign macro and choose "test" (or whatever you chose to call it) and OK.

HTH

DominicB

 

[qmp]

Thanks DominicB it worked great.

 

[qmp]

A little more help with this...

I use the code that DominicB gave me and it worked great but I need a little more help with it.

I'm useing it for work orders at work. It opens up the form page with this code but it goes to the first line. I need it to go to the next open line. As I add to it, the data will add up to a few thousand lines. I need it to go to the open line to save time. If I use the toolbar>data>form... it open the next open line. Others at work will also use the program and I want to make it easy and stupid proof.

Thanks...