Rixn
Board Regular
- Joined
- Jun 4, 2005
- Messages
- 119
- Office Version
- 2021
- Platform
- Windows
I have the following:
* a drop-down list (linked to cell M1)
* an Image ActiveX Control container (generated with the Camera button, as i assume that will be the same)
When I select alternatives in the drop-down list different images appear in the Image containter.
I have stored the images in the "Img" sheet, starting with cell A1, A2 and so on.
The Image container is linked to a named range (ImgPos) that uses the INDIRECT formula to get the right image cell.
It picks different cells depending on which alternative I chose in the drop-down list.
So far, so good!
Now, I want to add the option to select <b>which Image container should be the one that shift images when I use the drop-down menu</b>.
I have added five Form Control Option Buttons (linked to cell N1) and corresponding Image containers.
The question:
How do I get the selected image in the drop-down menu to change in the right Image container based on which option button is checked?
* a drop-down list (linked to cell M1)
* an Image ActiveX Control container (generated with the Camera button, as i assume that will be the same)
When I select alternatives in the drop-down list different images appear in the Image containter.
I have stored the images in the "Img" sheet, starting with cell A1, A2 and so on.
The Image container is linked to a named range (ImgPos) that uses the INDIRECT formula to get the right image cell.
It picks different cells depending on which alternative I chose in the drop-down list.
So far, so good!
Now, I want to add the option to select <b>which Image container should be the one that shift images when I use the drop-down menu</b>.
I have added five Form Control Option Buttons (linked to cell N1) and corresponding Image containers.
The question:
How do I get the selected image in the drop-down menu to change in the right Image container based on which option button is checked?