Active X Control Combo Box to give result in cell. Then VBA VLookup to place notes image in cell but does not work how I need it to

[CrustyR1]

Hi All, hopeflully someone can help with this one.

I have a sheet (Entry Form) that has a Active X combo Box C35 ("1 Door Base" - which doesn't show ) which works well and gives result in linked cell E35. I have a VBA VLookup looking at sheet 2 (Images) to find the match in E35 and show a notes image in F35. This all seems to work however I have to select E35, click on formula bar which is text only and then hit enter. After this the notes image and text "image" shows. I would like to be able to have the notes image show without the click & enter in formula bar as column E in grey gets hidden.

For some reason there is a need to select E35 call / formula bar for it to work. Auto calc is on and double clicking in E35 does nothing.

Cabinet Order Form_V6_WIP_3.xlsm
	B	C	D	E	F
33	Line No	Cabinet Type		Cabinet Code
34
35	1			1 Door Base	Image
36	2			1 Door Base	Image
37	3			2 Door Base	Image
38	4			1 Door Base	Image
39	5
40	6
41	7
42	8
43	9
44	10
Entry Form

 

[CrustyR1]

Thats just because you have no trigger to fire the code into action. The combobox change will act as a trigger. Or your original code would trigger if you changed the cells yourself rather than asking the combobox to change them which is what you are doing by reinputting them.

Oh...I see. Yes, the combobox needs to be the change & trigger the result. ?

 

[CrustyR1]

Thats just because you have no trigger to fire the code into action. The combobox change will act as a trigger. Or your original code would trigger if you changed the cells yourself rather than asking the combobox to change them which is what you are doing by reinputting them.

It worked.... hoooray! Thankyou very much steve the fish.