S
S Beals
I have 2 sheets, one with a list of company names for a drop down list
The second sheet has several columns, the first of which is the company name
In the fields under the company name column, I set up data validation and
set it to look up from the first sheet (I named the list first) "CompanyList"
The drop down list works fine if entering from the worksheet itself.
But if I choose "form" from the "Data" menu, the basic form comes up with
all the fields, but there is no drop down for the company field
I don't want to create a combo box or use VB programming, since this is a
very simple lookup and doesn't require anything else to be filled in
automatically
How do I get the drop down list to show on the Excel form?
The second sheet has several columns, the first of which is the company name
In the fields under the company name column, I set up data validation and
set it to look up from the first sheet (I named the list first) "CompanyList"
The drop down list works fine if entering from the worksheet itself.
But if I choose "form" from the "Data" menu, the basic form comes up with
all the fields, but there is no drop down for the company field
I don't want to create a combo box or use VB programming, since this is a
very simple lookup and doesn't require anything else to be filled in
automatically
How do I get the drop down list to show on the Excel form?