View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Drop-Down Menus in 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






" 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