Checking user defined types for Nothing

[jayklmno]

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?

[Tom Ogilvy]

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?

[jayklmno]

When I check an element, like ubound() I get a subscript error and it tells
me ubound(UDT) = nothing.

Is there a way to phrase the ubound statement that won't bomb out the code?

"Tom Ogilvy" wrote:

> 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?

[Chip Pearson]

UBound is used only for arrays, not user defined types.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"jayklmno" <jayklmno@discussions.microsoft.com> wrote in message
news:C0F90D03-3AF0-4BA0-97EA-DA23860969CB@microsoft.com...
> When I check an element, like ubound() I get a subscript error
> and it tells
> me ubound(UDT) = nothing.
>
> Is there a way to phrase the ubound statement that won't bomb
> out the code?
>
> "Tom Ogilvy" wrote:
>
>> 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?

[jayklmno]

This user defined type is an array. Ubound works normally on this if it is
intialized, but since it's not been intialized, how do I test that?

"Chip Pearson" wrote:

> UBound is used only for arrays, not user defined types.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "jayklmno" <jayklmno@discussions.microsoft.com> wrote in message
> news:C0F90D03-3AF0-4BA0-97EA-DA23860969CB@microsoft.com...
> > When I check an element, like ubound() I get a subscript error
> > and it tells
> > me ubound(UDT) = nothing.
> >
> > Is there a way to phrase the ubound statement that won't bomb
> > out the code?
> >
> > "Tom Ogilvy" wrote:
> >
> >> 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?
>
>
>

[Chip Pearson]

Post your code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"jayklmno" <jayklmno@discussions.microsoft.com> wrote in message
news:92B1AFE5-0D22-4878-AC34-9BEAAD84ABCB@microsoft.com...
> This user defined type is an array. Ubound works normally on
> this if it is
> intialized, but since it's not been intialized, how do I test
> that?
>
> "Chip Pearson" wrote:
>
>> UBound is used only for arrays, not user defined types.
>>
>>
>> --
>> Cordially,
>> Chip Pearson
>> Microsoft MVP - Excel
>> Pearson Software Consulting, LLC
>> www.cpearson.com
>>
>>
>> "jayklmno" <jayklmno@discussions.microsoft.com> wrote in
>> message
>> news:C0F90D03-3AF0-4BA0-97EA-DA23860969CB@microsoft.com...
>> > When I check an element, like ubound() I get a subscript
>> > error
>> > and it tells
>> > me ubound(UDT) = nothing.
>> >
>> > Is there a way to phrase the ubound statement that won't
>> > bomb
>> > out the code?
>> >
>> > "Tom Ogilvy" wrote:
>> >
>> >> 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?
>>
>>
>>