I have a worksheet that has several .jpg images on it. I want to be able to insert a solid shape over the .jpg images if certain conditions are met. For example, I have picture.jpg pasted over cells F10:F14. If the value in cell G17 = 0, then I want a green box to show up over picture.jpg that blocks out the picture entirely. If G17 > 0, then I want the picture to remain visible on the worksheet. I'm not very skilled with VBA at all so I was hoping someone could help me out.
thank you.
Hello
Some basic code would be:
This is on a Command Button and shows/hides Rectangle 2 on Sheet 1.
Sub Button1_Click() Select Case Sheet1.Range("G17") Case Is = 0 Sheet1.Shapes("Rectangle 2").Visible = True Case Is = 1 Sheet1.Shapes("Rectangle 2").Visible = False End Select End Sub
DBY
Last edited by DBY; 07-21-2016 at 09:51 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks