Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Box
I have a combo box linked to cells in a column Cell B5 to B10. In Cell B4 the
numbers 1 to 6 appear. I want Cell A5 to contain the text from the selected cell. For instance B7 contains the word Sales, when Sales is selected from the combo box the number 3 appears in Cell B4 and A5. I require the word Sales to appear in Cell A5. Can you advise how to do this? Many thanks for any assistance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking a form combo box... results from the combo box to another | Excel Discussion (Misc queries) | |||
combo reference on another combo box for picking address etc. | Excel Worksheet Functions | |||
Can one combo box control the data in a different combo box | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) |