Switching from InputBox to UserForm?

[Sean Stuber]

How can i replace the use of an Input box where the user is prompted to
type info with a form that has a dropdown list of appropriate items?
I've never created the userforms before, is there an easy way to get
this done?

thanks,
sean

 

[Guest]

Hi Sean

Simply create a Userform (Insert--> Userform), and then use a ComboBox control. Afterwards you can populate the Combobox using the .AddItem method

SuperJas.

 

[Bob Phillips]

Hi Sean,

Here are some links to check out

http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.

http://support.microsoft.com/default.aspx?kbid=161514
XL97: How to Use a UserForm for Entering Data

http://support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data

http://support.microsoft.com/?id=168067
XL97: WE1163: "Visual Basic Examples for Controlling UserForms"

http://support.microsoft.com/default.aspx?scid=kb;en-us;829070
How to use Visual Basic for Applications examples to control UserForms in
Microsoft Excel
--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Sean Stuber]

the user form is looking good.
however, i am unclear about how to add items to it. I want to use a
list of items stored within cells of a worksheet.

thanks,
sean

 

[Bob Phillips]

Take a look at the section entitled
How to use the RowSource property to populate a ListBox control with cells
on a worksheet

in

http://support.microsoft.com/default.aspx?scid=kb;en-us;829070
How to use Visual Basic for Applications examples to control UserForms in
Microsoft Excel

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)