PHP isset function in VBA

T

Tomski

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
 
B

broro183

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..
 
T

Tomski

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

Cheers

Tom
 
T

Tomski

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.
 
B

broro183

no problem, pleased I could help.

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

broro183

no problem, pleased I could help.

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

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

why can`t close mysql_connect? 0
Problem with SET & REF function 0
How tot convert PHP-code into ASP-code 3
Excel - Wich Function should I use? 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Justification function versus wide spaces 0
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Word macro that can call cells out of Excel for a find and replace 0

Top