hi,
I'm building a status report.
For the performance indicators, I would like to display them as a colored circle. I have three images inside a imagelist content control, but I'm searching for a way to be able to change conveniently between the three images. Here's what it look like :
I already tried 3 options.
- A drop-down box with images inside to select the right color
- Clicking directly on the image to switch to another color
- Creating a userform to select a color.
The First one would be my favorite way of doing things, but when I used the "Microsoft ImageComboBox Control", I wasn't able to fill it with the image in my imageList. Just no image, nor text was being displayed, like so :
I used this piece of VBA code to fill the combobox which I inserted in a button_click function :
Set IndchPr.ImageList = ImageList21
ImageList21 is the name of the image list which have the 3 images (index 1 for green, 2 for yellow and 3 for red). IndchPr is the image combobox.
For the second solution, I think it couldn't easily be done because what tells it which image there is? If it can be done though, It would be my second prefered solution.
For the Userform solution, I couldn't call the image controlers on my document, I didn't know how.
Thanks in advance!
Jonathan