Simple Question about combobox

  • Thread starter Thread starter ryan.fitzpatrick3
  • Start date Start date
R

ryan.fitzpatrick3

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combobox help.....really easy I imagine 2
Need Help with VLOOKUP 4
Combobox filtering 2
Combobox linked to Custom Views 17
More combobox questions 1
preventing comboboxes from triggering when sheet copied 1
Raise Event Problem 4
combo box 1

Back
Top