Create a listbox

D

Dawn

How do a create a list box in Excel and drag it down so
each row in the spreadsheet will have the list box.

Thanks
 
J

Jim

Perhaps you want to use Data>Validation>Settings tab>Allow>List where you
enter an equal sign and a named range containing the choices (=MyList), a
range of cells (K2:K20) containing your choices, or the choices each
separated by a comma (US).
 
N

Norman Harker

Hi Dawn!

Type out a list somewhere.
Select the list and type (e.g.) MyList in the name box to the left of
the formula bar

Select the first cell of the column which is to contain the listbox
Data > Validation
Select "List" from the drop down
Type =MyList in the Source
Follow your nose with the rest of the validation

Once happy
Copy down as usual.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top