Data Validation - Drop Down for User Form

[wx4usa]

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!

 

[Chip Pearson]

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)

 

[wx4usa]

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)

Hi Chip, Thanks for the feedback. How do I input values for teh Drop
Down combo box on the form?