View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish
 
Posts: n/a
Default Drop-Down Menus in Data Entry Form?

You can't show a data validation list in the standard data form.
If you can use add-ins, you could try John Walkenbach's Enhanced Data
Form. It's a free add-in that allows combo boxes, so it could display a
list of items.

http://j-walk.com/ss/dataform/index.htm

wrote:
I have a drop-down menu containing the months of the year in my
spreadsheet. I want to train people to enter data using the data entry
form (Data -- Form). Is there any way to make this drop-down menu
appear in the data entry form?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html