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.

Userform1.Show

See also this page
http://support.microsoft.com/default...b;EN-US;829070



--
Regards Ron de Bruin
http://www.rondebruin.nl



"chorismos" <(E-Mail Removed)> wrote in message news:0EC7332A-5B71-42F5-9961-(E-Mail Removed)...
>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.

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" <(E-Mail Removed)> wrote in message
news:0EC7332A-5B71-42F5-9961-(E-Mail Removed)...
> 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.