Adding Pull Down Menus in Excel
Adding Pull Down Menus in Excel
(OP)
Hello,
I am having a hard time trying to get pull down menus made in Excel. I'm looking to have a whole column have cells that will give a pull down menu with 4 choices. Could somebody help me on how to get this done?
Thanks.
I am having a hard time trying to get pull down menus made in Excel. I'm looking to have a whole column have cells that will give a pull down menu with 4 choices. Could somebody help me on how to get this done?
Thanks.





RE: Adding Pull Down Menus in Excel
on the "Settings" tab:
Allow --> List
Source --> (select cells with your desired input value list)
Then highlight the cell and drag with the right mouse button to select your column of input cells, and select "fill formatting only". This will copy the data validation (pull down menus) to your column of input cells.
RE: Adding Pull Down Menus in Excel
No VBA is required.
RE: Adding Pull Down Menus in Excel
I liked that.
Combo boxes seem to sit on top of the spreadsheet while these fit in a cell. Nice.
If only I could define an output the way I do combo boxes (Control); i.e. put a value into another cell. I guess I could with an IF statement.
JMW
www.ViscoAnalyser.com
RE: Adding Pull Down Menus in Excel
It is a useful option.
JMW
www.ViscoAnalyser.com
RE: Adding Pull Down Menus in Excel
Robert Mote
www.motagg.com