Curious IsNull test
 

Why, when my code goes through this segment, is neither message box
displayed?

If IsNull(test) Then
MsgBox "Test is now null"
Else
MsgBox "<" & test.Value & ""
End If

Curious IsNull test
 

What data type is 'test'?

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Tim" wrote in message
oups.com...
Why, when my code goes through this segment, is neither message
box
displayed?

If IsNull(test) Then
MsgBox "Test is now null"
Else
MsgBox "<" & test.Value & ""
End If

Curious IsNull test
 

Hi Tim

What is test? Could it be that you have an errorhandler that is trapping an
error and therefore skipping one of the message boxes?

If test is a range then it will never be null. It is Nothing until you set
it and if it is set to a range which contains no data then it's Value
property is Empty.

Hope this helps
Rowan

"Tim" wrote:

Why, when my code goes through this segment, is neither message box
displayed?

If IsNull(test) Then
MsgBox "Test is now null"
Else
MsgBox "<" & test.Value & ""
End If

Curious IsNull test
 

Dim cntNew, test As MSForms.Control

I have discovered part of the problem is that an error handler grabs
control. Let me just investigate this information futher.

Much thanks,
-Tim

Curious IsNull test
 

Ok. Question answered. Many thanks.