Nothing?

  • Thread starter Thread starter CK
  • Start date Start date
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)
 
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)
Click to expand...
 
Back
Top