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?