Dropdown list multiple column

[john5599]

Hi please need a help.


I have a excel sheet as given below. I need to make a drop down list of that, when I select item name from the dropdown list , item code also come in the next column. Is it possible .

Sheet1[TABLE="class: html-maker-worksheet"]
<thead>[TR]
[TH][/TH]
[TH]A[/TH]
[TH]B[/TH]
[/TR]
</thead><tbody>[TR]
[TH]1[/TH]
[TD]Item Name[/TD]
[TD]Code[/TD]
[/TR]
[TR]
[TH]2[/TH]
[TD]TRIM CLIP ON LED PANEL 6W 6500K[/TD]
[TD]LHEAABP7IL1W006[/TD]
[/TR]
[TR]
[TH]3[/TH]
[TD]TRIM CLIP ON LED PANEL 12W 6500K[/TD]
[TD]LHEAABP7IL1W012[/TD]
[/TR]
[TR]
[TH]4[/TH]
[TD]TRIM CLIP ON LED PANEL 18W 6500K[/TD]
[TD]LHEAABP7IL1W018[/TD]
[/TR]
[TR]
[TH]5[/TH]
[TD="bgcolor: #92D050"]LED ADORE 10W B22 CDL 3STAR LAMP[/TD]
[TD]LHLDEUEEML8R010[/TD]
[/TR]
[TR]
[TH]6[/TH]
[TD="bgcolor: #92D050"]LED ADORE 9W B22 CDL 3 STAR LAMP[/TD]
[TD]LHLDEUEEML8R009[/TD]
[/TR]
[TR]
[TH]7[/TH]
[TD]TRIM CLIP ON PANEL 24W 6500K[/TD]
[TD]LHEAABP7IL1W024[/TD]
[/TR]
[TR]
[TH]8[/TH]
[TD]TRIM CLIP ON LED PANEL 6 W 4000K[/TD]
[TD]LHEAABP6IL1W006[/TD]
[/TR]
</tbody>[/TABLE]
Excel 2007

 

[Akuini]

You're welcome, glad to help, & thanks for the feedback.

 

[john5599]

Can we pause stop macro with any short key while not required, because I can not use left arrow or down arrow to scroll it struck on the drop down combo. field. I can use only right arrow and esc key to move columns

regards

 

[Akuini]

Can we pause stop macro with any short key while not required, because I can not use left arrow or down arrow to scroll it struck on the drop down combo. field. I can use only right arrow and esc key to move columns

regards

I'm sorry, I don't know how to pause/stop the code using a keyboard shortcut. But I think it's doable by using double click event in the combobox.
If you're ok with that just let me know.