N
need help
Is there anyway to create a drop down box without going
through visual basics?
through visual basics?
N
Norman Harker
Hi!
Try using Data > Validation
Select the list drop down
You can provide the list in the dialog by separating items with your
usual separator (, or
Or you can give a range for the list if it is on the same sheet
Or you can give a range name for the location of the list.
Seasons Greetings
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Try using Data > Validation
Select the list drop down
You can provide the list in the dialog by separating items with your
usual separator (, or
Or you can give a range for the list if it is on the same sheet
Or you can give a range name for the location of the list.
Seasons Greetings
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.