How do I make a commandbutton in Excel 'launch' a custom form?

C

chorismos

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.
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set focus (and select text) on a text box on a modeless userform? 0
How to enumerate buttons on user form 2
How do I clear a form? 0
Using a variable to select a CommandButton and setting the caption 4
Commandbutton question 2
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Adding custom menus to existing excel application 0
HOW CAN I WRITE A CODE TO A COMMANDBUTTON CREATED PROGRAMMATICALLY 1

Top