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.
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 |