I have a combobox with 8 people names. I have it linked to cell D6. It
works fine except when I click the 3rd name, lets say Tom, cell D6
shows up as 3, name 6 Maria shows up as 6 instead of Maria. How do I
get D6 to match whatever name is selected in the combo box?
Ryan
merjet - 18 Dec 2007 22:42 GMT
I suspect you used a ComboBox from the Forms toolbar.
If you use a ComboBox from the Control Toolbox, the
LinkedCell will show the value selected, not its ordinal
number.
Hth,
Merjet