Testing object value
 

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!

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!

Testing object value
 

Thanks Rick - a double negative equals a positive - and it works perfectly!

"Rick Rothstein" wrote:

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!

.