Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Question about the Null character in VBA 1

Status
Not open for further replies.

russeldraper

Technical User
Jul 9, 2003
10
0
0
US
Hello All,
I was just wonder if there was a function in VBA that would let me now if a variable is null. For instance, in Java they have a function IsNull(<variable>) and it returns true if the variable is null, hence the name. I haven't been able to find any way in VBA to check if a variable is null or not.

Any input would be most appreciated.
 
IsNull is it!!

if isnull(blah) then
do this
else
do that
end if
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top