Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with drop down selection list box
To all,
I have a set of part numbers: FX1999 FX2000 FCG344 FHJ7867 I want to be able to have a drop down box or list type of thing that allows the user to select one of these parts. I then want the part number to be shown in cell C2 of sheet1. I would prefer an answer that uses a Macro as opposed to defining names/lists etc, and would like the box to be placed where I choose it on the spreadsheet. i.e. not linked to a cell like the data validation-lists approach. Is this possible? I was thinking of using a combo box or list box. Thanks for your help in advance, Regards Joseph Crabtree |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down list should remember selection. | Excel Discussion (Misc queries) | |||
drop down list selection | Excel Discussion (Misc queries) | |||
Adding another selection to a drop down list | Excel Discussion (Misc queries) | |||
Selection of Drop down list that allows you to go to a particular cell | Excel Worksheet Functions | |||
quick selection drop down list | Excel Worksheet Functions |