Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I make a commandbutton in Excel 'launch' a custom form?
I have created a customised form in Excel and want the command button in the
spreadsheet to 'launch' or 'activate' the customised form so that the user can input data and perform a calculation on the form. I cannot find anything describing how to do this; eg it seems that you need to input a 'Private Sub CommandButton1_Click()' routine and set a condition eg 'If CommandButton1.Caption = "OK" Then' but how do you reference or link the click event to the userform. Do you use an 'activate' type command? How do you reference the userform? Been looking everywhere for this simple thing. Grateful for help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I make a commandbutton in Excel 'launch' a custom form?
Userform1.Show
See also this page http://support.microsoft.com/default...b;EN-US;829070 -- Regards Ron de Bruin http://www.rondebruin.nl "chorismos" wrote in message ... I have created a customised form in Excel and want the command button in the spreadsheet to 'launch' or 'activate' the customised form so that the user can input data and perform a calculation on the form. I cannot find anything describing how to do this; eg it seems that you need to input a 'Private Sub CommandButton1_Click()' routine and set a condition eg 'If CommandButton1.Caption = "OK" Then' but how do you reference or link the click event to the userform. Do you use an 'activate' type command? How do you reference the userform? Been looking everywhere for this simple thing. Grateful for help. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I make a commandbutton in Excel 'launch' a custom form?
Get a button from the forms toolbar, and when you drag it onto the
worksheet, you will immediately be prompted to assign a macro. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "chorismos" wrote in message ... I have created a customised form in Excel and want the command button in the spreadsheet to 'launch' or 'activate' the customised form so that the user can input data and perform a calculation on the form. I cannot find anything describing how to do this; eg it seems that you need to input a 'Private Sub CommandButton1_Click()' routine and set a condition eg 'If CommandButton1.Caption = "OK" Then' but how do you reference or link the click event to the userform. Do you use an 'activate' type command? How do you reference the userform? Been looking everywhere for this simple thing. Grateful for help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i make a commandbutton run a macro?? | New Users to Excel | |||
Is it possible to make a Button on a tool bar to launch an Add-in | Excel Discussion (Misc queries) | |||
How can I make a custom button in one Excel form to e-mail easily. | Excel Programming | |||
how 2 launch user form .. | Excel Programming | |||
Launch form from Array | Excel Programming |