Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform Commands - Switching Question | Excel Discussion (Misc queries) | |||
Switching between Workbooks | Excel Discussion (Misc queries) | |||
Switching Information | Excel Discussion (Misc queries) | |||
Inputbox or UserForm | Excel Programming | |||
Switching userfoms | Excel Programming |