Edit: Heh. xposted :P
I have a sheet set up that has a dropdown, but does not use a combo box, but it works really well for what I do, and sounds like it might work for you as well.
Look into Data Validation. I have a cell (A2) set up as
Data Validation--
Allow : List
Source : =$E$1:$E$9 ( where my list of choices are)
E1:E9 has my long error codes in English that users can read and understand. âThe user entered in an invalid valueâ
F1:F9 has a numeric code - 1,2,3, etc
H1:H9 has the related short error code abbreviations that no one remembers. âID10Tâ
In the next cell over, I have
=IF(ISERROR((VLOOKUP(A2,$E$1:$H$9,2))),"",CHOOSE(((VLOOKUP(A2,$E$1:$H$9,2))),$H$1,$H$2,$H$3,$H$4,$H$5,$H$6,$H$7,$H$8,$H$9))
That allows me to pull the âshortâ code (ID10T) for the longer error code selected in the dropdown.
I know itâs not exactly what you asked for, but it works well for me, and it might work well for you, or others ;)
I have a sheet set up that has a dropdown, but does not use a combo box, but it works really well for what I do, and sounds like it might work for you as well.
Look into Data Validation. I have a cell (A2) set up as
Data Validation--
Allow : List
Source : =$E$1:$E$9 ( where my list of choices are)
E1:E9 has my long error codes in English that users can read and understand. âThe user entered in an invalid valueâ
F1:F9 has a numeric code - 1,2,3, etc
H1:H9 has the related short error code abbreviations that no one remembers. âID10Tâ
In the next cell over, I have
=IF(ISERROR((VLOOKUP(A2,$E$1:$H$9,2))),"",CHOOSE(((VLOOKUP(A2,$E$1:$H$9,2))),$H$1,$H$2,$H$3,$H$4,$H$5,$H$6,$H$7,$H$8,$H$9))
That allows me to pull the âshortâ code (ID10T) for the longer error code selected in the dropdown.
I know itâs not exactly what you asked for, but it works well for me, and it might work well for you, or others ;)