View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Checking user defined types for Nothing

You would have to check the individual elements I would think.

a UDT is not an object, so is nothing wouldn't work.

--
Regards,
Tom Ogilvy



"jayklmno" wrote:

I have a user defined type that is not getting initialized under a certain
procedure and when it gets to a point, I need to check and see if it has been
initialized. I acnnot get any combination of Is Nothing, IsNull or anything
else I can think of to get it to discover if the UDT = Nothing.

Any suggestions?