Nothing?


C

CK

What does it mean by setting an object variable to "Nothing"?

Thanks!!!
 
Ad

Advertisements

B

Bob Phillips

Hi CK,

Nothing is a VB (and hence VBA) keyword that only applies to object
variables, and determines whether a variable has a valid object reference.
When an object variable is first created it has a 'value' of Nothing (or put
more accurately, can be tested to be Nothing), and when assigned via the
Set statement, it has a valid object reference.

I suppose it is somewhat akin to testing a string variable for blank.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Ad

Advertisements

C

CK

Bob Phillips said:
Hi CK,

Nothing is a VB (and hence VBA) keyword that only applies to object
variables, and determines whether a variable has a valid object reference.
When an object variable is first created it has a 'value' of Nothing (or put
more accurately, can be tested to be Nothing), and when assigned via the
Set statement, it has a valid object reference.

I suppose it is somewhat akin to testing a string variable for blank.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is Nothing 4
Not Nothing 5
Date to nothing 3
if range=nothing then 2
If Not c Is Nothing Then 3
If nothing found ... 3
replacing , with nothing ? 2
Range is nothing 6

Top