PHP isset function in VBA
 

Just a quick one.

Is there a similar function in VBA as the isset function in PHP, i.e.
function which returns true if a variable is set.

Cheers



--
Tomsk
-----------------------------------------------------------------------
Tomski's Profile: http://www.excelforum.com/member.php...fo&userid=2682
View this thread: http://www.excelforum.com/showthread.php?threadid=50672

PHP isset function in VBA
 

hi,
Have a look in the VBE help files at the explanations for "isnull"
"isempty". One of these should do what you are after.

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience..

--
broro18
-----------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...fo&userid=3006
View this thread: http://www.excelforum.com/showthread.php?threadid=50672

PHP isset function in VBA
 

A friend suggested comparing the variable to "IS Nothing" which seems to
work if anybody was wondering.

Cheers

Tom


--
Tomski
------------------------------------------------------------------------
Tomski's Profile: http://www.excelforum.com/member.php...o&userid=26824
View this thread: http://www.excelforum.com/showthread...hreadid=506720

PHP isset function in VBA
 

Cheers for the suggestion Rob, the IS function as you suggested is wha
I was looking for. Because I am checking if a function that returns
range has worked, the IS nothing is the one to use.



--
Tomsk
-----------------------------------------------------------------------
Tomski's Profile: http://www.excelforum.com/member.php...fo&userid=2682
View this thread: http://www.excelforum.com/showthread.php?threadid=50672

PHP isset function in VBA
 

no problem, pleased I could help.

Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=506720

PHP isset function in VBA
 

no problem, pleased I could help.

Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=506720