Form question...

qmp

New Member
Joined
Feb 17, 2004
Messages
27
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...
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
Good evening qmp

Use this simple macro assigned to your button :

Code:
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

New Member
Joined
Feb 17, 2004
Messages
27
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...
 

Forum statistics

Threads
1,141,626
Messages
5,707,491
Members
421,511
Latest member
mgroah1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top