| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking user defined types for Nothing
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Checking user defined types for Nothing
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Checking user defined types for Nothing
UBound is used only for arrays, not user defined types.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "jayklmno" wrote in message ... 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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Checking user defined types for Nothing
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" wrote in message ... 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? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Checking user defined types for Nothing
Post your code.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "jayklmno" wrote in message ... 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" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Standard chart types over-ridden by user-defined 'default' | Charts and Charting in Excel | |||
| subs or functions with user defined types | Excel Programming | |||
| User-defined data type; Error: Only User-defined types... | Excel Programming | |||
| Unable to add user-defined data types to a collection | Excel Programming | |||
Hybrid Mode
