| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - Drop Down for User Form
I have my user form working fine now. Next question, how do I add a
drop down - data validation to the fields in the user form? Is this possible in Excel? I have 2007. Thank you! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation - Drop Down for User Form
Data Validation is 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, LLC www.cpearson.com (email on web site) On Thu, 23 Oct 2008 13:21:02 -0700 (PDT), wx4usa wrote: I have my user form working fine now. Next question, how do I add a drop down - data validation to the fields in the user form? Is this possible in Excel? I have 2007. Thank you! |
|
#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? |
| Reply |
| 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) | |||
Linear Mode
