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

	A	B
1	Item Name	Code
2	TRIM CLIP ON LED PANEL 6W 6500K	LHEAABP7IL1W006
3	TRIM CLIP ON LED PANEL 12W 6500K	LHEAABP7IL1W012
4	TRIM CLIP ON LED PANEL 18W 6500K	LHEAABP7IL1W018
5	LED ADORE 10W B22 CDL 3STAR LAMP	LHLDEUEEML8R010
6	LED ADORE 9W B22 CDL 3 STAR LAMP	LHLDEUEEML8R009
7	TRIM CLIP ON PANEL 24W 6500K	LHEAABP7IL1W024
8	TRIM CLIP ON LED PANEL 6 W 4000K	LHEAABP6IL1W006

<thead>
</thead><tbody>
</tbody>

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.