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!

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!

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?