Switching from InputBox to UserForm?
 

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



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Switching from InputBox to UserForm?
 

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.

Switching from InputBox to UserForm?
 

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...b;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" wrote in message
...
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



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Switching from InputBox to UserForm?
 

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



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Switching from InputBox to UserForm?
 

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...b;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" wrote in message
...
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



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!