Mel Smith
Well-known Member
- Joined
- Dec 13, 2005
- Messages
- 1,023
- Office Version
- 365
- Platform
- Windows
I am trying to show the value of a combo box in another cell but I'm not getting the results I expect.
I have a combobox , using the range N1:N36, linked to cell A3. The combobox is situated over cell A3 and hiding it from view.
What I'd like to do is have the value selected in the combobox also shown in cell A1. However, when I select a name in the combobox, the value in A3 (and also in cell A1) is a number which corresponds to the place in the list. For example the third name in the list (N1:N36) is Jones. If this is selected bot A3 and A1 display 3 and not the name.
What am I doing wrong?
Mel
I have a combobox , using the range N1:N36, linked to cell A3. The combobox is situated over cell A3 and hiding it from view.
What I'd like to do is have the value selected in the combobox also shown in cell A1. However, when I select a name in the combobox, the value in A3 (and also in cell A1) is a number which corresponds to the place in the list. For example the third name in the list (N1:N36) is Jones. If this is selected bot A3 and A1 display 3 and not the name.
What am I doing wrong?
Mel