Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Adding a button to a spreadsheet...
Hello, I am trying to figure out how to add a button to a spreadsheet that will launch the UserForm that I have created for inputing data onto that ss. This has to be easier than it is to find out how to go about doing this. Thanks, PZan -- PokerZan ------------------------------------------------------------------------ PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480 View this thread: http://www.excelforum.com/showthread...hreadid=389163 |
#2
|
|||
|
|||
Hello-
Depending on version & intent you can either bring up the Forms Toolbar and create your button using the Button tool and assign a Macro to it then or later. Or, you can turn on the Control Box Toolbar & use the Command Button tool to create the button and write your VBA. HTH |:) "PokerZan" wrote: Hello, I am trying to figure out how to add a button to a spreadsheet that will launch the UserForm that I have created for inputing data onto that ss. This has to be easier than it is to find out how to go about doing this. Thanks, PZan -- PokerZan ------------------------------------------------------------------------ PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480 View this thread: http://www.excelforum.com/showthread...hreadid=389163 |
#3
|
|||
|
|||
First, enable the Forms toolbar (ViewToolbarsForms) Then click the "Button"
button and drag on the sheet to the size you want, then assign the macro to it "PokerZan" wrote: Hello, I am trying to figure out how to add a button to a spreadsheet that will launch the UserForm that I have created for inputing data onto that ss. This has to be easier than it is to find out how to go about doing this. Thanks, PZan -- PokerZan ------------------------------------------------------------------------ PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480 View this thread: http://www.excelforum.com/showthread...hreadid=389163 |
#4
|
|||
|
|||
DOH! Thanks guys... for not flaming me, geez that was too simple. PZan -- PokerZan ------------------------------------------------------------------------ PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480 View this thread: http://www.excelforum.com/showthread...hreadid=389163 |
#5
|
|||
|
|||
None of the Excel news groups are populated by flamers.
Gord Dibben Excel MVP On Thu, 21 Jul 2005 16:59:52 -0500, PokerZan wrote: DOH! Thanks guys... for not flaming me, geez that was too simple. PZan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding five new rows every 40 rows in a spreadsheet? | Excel Discussion (Misc queries) | |||
how do i create a button within a spreadsheet | Excel Discussion (Misc queries) | |||
How do I set up a radio button on an Excell spreadsheet | Excel Discussion (Misc queries) | |||
adding a command button to an excel cell? | Excel Discussion (Misc queries) | |||
Adding Button to Tool Bar | Excel Discussion (Misc queries) |