Thread: Data Validation - Drop Down for User Form
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default 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!
Reply With QuoteReply With Quote