| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - Drop Down for User Form
On Oct 23, 3:42*pm, Chip Pearson wrote:
DataValidationis a function of the Excel UI and isn't available as such on UserForms. *However, you can put a drop down combobox on the UserForm and set the Style property to 2 - fmStyleDropDownList. This will prevent the user form entering any value that is not in the list. Cordially, Chip Pearson Microsoft Most Valuable Professional * * Excel Product Group Pearson Software Consulting, LLCwww.cpearson.com (email on web site) On Thu, 23 Oct 2008 13:21:02 -0700 wrote: I have my user form working fine now. Next question, how do I add a drop down - datavalidationto the fields in the user form? Is this possible in Excel? *I have 2007. Thank you! Hi Chip, Thanks for the feedback. How do I input values for teh Drop Down combo box on the form? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation of user input | Excel Worksheet Functions | |||
| User Form - Get Data From Drop List | Excel Discussion (Misc queries) | |||
| User form Samples (to query data) | Excel Discussion (Misc queries) | |||
| how do I add data validation dropdown lists to a Form | Excel Worksheet Functions | |||
| Data Entry Alert in User Form | Excel Discussion (Misc queries) | |||
Threaded Mode
