Combo Box Drop Down Selection Makes a desired Value Appear in a Cell

[elmattio]

I have searched and have not been able to find an answer to this question so it might be a little unique possibly. I have an ActiveX combo box that I am trying to do something with. The text that I want to appear in the combo box is already there and I did this by creating a list and referencing it to the combo box. So the combo box has the following four items in its drop down:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Boat<o></o>
Car<o></o>
Plane<o></o>
Walk<o></o>
Now the part I cannot figure out is how to make a selected value appear in another cell based on what was selected in the combo box. For example, if boat is selected in the combo box, then I want the value 25 to appear in a cell. If Plane is selected in the combo box, I want the value of 100 to appear in a cell. For walk 5, and for car 22.<o></o>
I know this can easily be done with data validation and a validation drop down list but I do not want to use that but need to have a combo box do it instead. I just don’t know if it cannot be done as a list or not and have experimented with INDEX but not having any luck there. I do not want to use any macros for this either.<o></o>
Basically I am wondering how I can make my combo box work just like data validation drop down menu bar with formatted values outputted into a cell. <o></o>
Any Help Would Be Greatly Appreciated,<o></o>
Thanks! <o></o>

 

[ChrisM]

Use the Linked Cell property of the combobox to get the output to appear in a specific cell.

Then turn your combobox into a multi-column combobox (again using the Properties window).

The second column will contain the number you want, 25, etc, the first column will contain the words. You may have to tinker around and reverse the order of those, haven't used a multicolumn box with a linked cell before.

Review the help file for the following properties:

Columncount
Columnwidths
Textcolumn
LinkedCell

 

[elmattio]

Re: Thanks!

Thanks for your response ChrisM. Messing around with columncount and columnwidths solved my problem. Now I can get my combo box text get its desired hidden number values to appear in a desired cell.

I went to three other websites and asked this question. The answers were always completly off and I feel as if they did not understand my question and/or just thought they had the answer but did not. People told me conditional formatting, data validation, and other things would solve my problem when I knew it wouldn't becasue I had tried those routes before asking for help. I should have come to this website first.

Again, thank you very much

 

[HORSEPOWER HERO]

Re: Thanks!

Hello Elmattio,

I have the same problem as you, would you mind explaining in more detail how you solved your problem?

Thanks and Kind Regards
Simon