Embedding Pictures in Excel

Tom_Insure · January 19th, 2011, 07:34 PM

Is it possible to embed picutres in Excel? I'm not sure where to start.

I want to embed a single picture than can be used on multiple worksheets, but also make the picture appear or disappear on given worksheet based on a condition in an IF statement.

Any help would be greatly appreciated.

Thanks

Tom

JP · January 26th, 2011, 12:17 PM

What I would do is insert an Image control on the worksheet, and set the Picture Property to the image I want to show or hide.

Then I would use the Worksheet_Calculate Event to check the value of your formula and hide or show the control accordingly.

For example, if I had a formula in A1 and wanted to hide the image when the result of the formula equals 1, I would use this code:

Code:

Private Sub Worksheet_Calculate()
  Me.Image1.Visible = (Range("A1").Value = 1)
End Sub

I didn't rename the image control so the default name of Image1 applies.

You'll need to insert the image in every worksheet, however, and duplicate the code in each sheet module.