Thread
:
Drop-Down Menus in Data Entry Form?
View Single Post
#
3
Posted to microsoft.public.excel.misc
Debra Dalgleish
Posts: n/a
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
Reply With Quote