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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Box
=INDEX(B5:B10,B4)
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "zephyr" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Box
If youo double click the combobox a macro should be create when you are in
design mode. To get into design mode 1) View menu - tool bars - Command control clik on triangle on tool bar. double click combobox 2) Then click on property on tool bar and again click combox Listfillrange should be B5:B10 3) Add the two ranges to the comboxbox code Private Sub ComboBox1_Change() Range("B4") = ComboBox1.ListIndex + 1 Range("A5") = ComboBox1.Text End Sub 4) On tool bar exit design mode by pressing triangle. 5) The combox box should not automatically change the two cells "zephyr" wrote: 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. |
Reply |
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) |