Drop-Down Menus in Data Entry Form?

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?

You could create a macro that displays the data|form dialog.

But when would you want to run that macro?

When the workbook opens?
When the worksheet is activated?
Only when the user wants to see it?

The line of code could be as simple as:

ActiveSheet.ShowDataForm






"[email protected]" 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?

--

Dave Peterson

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

[email protected] 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