How to let a combobox appear?

Posted by Thankful on July 01, 2001 12:32 AM

Hey people,

I don't know how to let a combobox appear with the message "Enter Name First"? For instance when someone click on a button and then it has to appear. Does anybody know how to do this? It's probably an easy thing to do for most people but I'm just starting with the VB editor. Thanks in advance.

Thankful

Posted by Cory on July 01, 2001 11:18 AM

I assume you have a button on your spreadsheet. When you click this button you want a form you made in VB Editor with a combobox on it to pop up and ask you to pick the first name.

If you haven't already, put a label on this form and make the caption: "Enter First Name"

Go back to your spreadsheet and, in design mode, double click on the button to access its code module in the click event handler. Put the following code in where "userform1" is the name of your form:

Load Userform1
Userform1.Show