View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default Testing object value

Try this...

If Not Worksheets("Sheet1").OLEObjects("Image2").Object.P icture Is Nothing
Then

--
Rick (MVP - Excel)



"mooresk257" wrote in message
...
I am working on setting up some code to test whether an image is loaded in
an
image box:

I use this to test to see if there is no image loaded:

If Worksheets("Sheet1").OLEObjects("Image2").Object.P icture Is Nothing
Then

How would I write this line to test if there IS an image?

Thanks!