I am trying to create an application for use in an office environment, and so VBA in Excel is more practical than a stand-alone VB application. I think I need a VBA loop that will be used to make an image "autocolour" if a corressponding check box is ticked, or grayscale if it is not, by default the box will be unticked and the image grayscale. There will be about 25 images and checkboxes. I made a macro to colour the image when ticked
[vbcode
ActiveSheet.Shapes("Picture 9").Select
Selection.ShapeRange.PictureFormat.ColorType = msoPictureAutomatic
[/Highlight]
However, this only works for one image and I need a separate macro for every image, and another macro to uncolour it when unticked. Therefore, I thought about using a loop, but I ma unsure how to use the Excel Check boxes from the form menu in VBA code. They are easier to edit, but do I need the VBA checkboxes from the VBA toolbox?

Also, can some suggest some loop code please for this scenario:
When any checkbox is ticked, it should run the code and the loop will do this:
if checkbox# = true then picture#=autocolour else picture# = grayscale
starting with i=1, to i=24
e.g. so if checkbox 14 was ticked, picture 14 would become colour

I have not made all my images and checkboxes yet, so I an easily name them specially if someone recommends it or maybe I will need an array?

Thanks