Hello i have inserted a image using control toolbox and set the value of the image to a cartain picture.

i would like the picture to change depending on a cell value e.g

if range("a1") = 1 then
image1.picture = "C:\pictures\apicture.jpg"
end if
how do i make this happen as i know the above code is not real it hopefully gives an idea of what i would like thanks