Referencing an image name by cell value

[Phox]

I have a userform with an image named "California".
The image is defaulted to be invisible.
I would like the image to become visible if the value of Range E1 is "California".

This is what I tried to do but it didnt work.

If Range("E1").Value = "California" Then
Range("E1").Value.Visible = True
End If

Can somebody please help me out?

 

[erik.van.geit]

Hello, Phox,
Try this:

Private Sub userform_initialize()
If Range("E1") = "California" Then
Me.Controls(Range("E1").Value).Visible = True
End If
End Sub

this works for me

regards,
Erik

 

[Phox]

Thanks, that works for what I need.

Just more a better understanding though, could you explain to me a little about Me.Controls? What it does, other likely applications for it, etc?

Thanks a ton!