Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have:
Public Type TPETC_COLS Sort As Integer AStart As Integer RStart As Integer SStart As Integer RComplete As Integer SComplete As Integer End Type But in the middle of the code I want to ensure all values in the type are set to 0, I just want to know if there is an easier way to do this rather than declaring each one as 0. Thanks. -- ********************* J Streger MS Office Master 2000 ed. MS Project White Belt 2003 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On way would be to declare a dummy variable as the same type. Then use lset
to reset sub abc( b as TPETC_COLS mydum as TPETC_COLS ' work with b, never touch mydum ' now to reset lset b = mydum ' b is now reset End Sub If you have a fixed array of these variables and you want reset them all, then you can use erase sub abc( b(0 to 10) as TPETC_COLS ' work with b, never touch mydum ' now to reset all the type variables in the array erase b ' all variables in b are now reset End Sub -- Regards, Tom Ogilvy "J Streger" wrote: I have: Public Type TPETC_COLS Sort As Integer AStart As Integer RStart As Integer SStart As Integer RComplete As Integer SComplete As Integer End Type But in the middle of the code I want to ensure all values in the type are set to 0, I just want to know if there is an easier way to do this rather than declaring each one as 0. Thanks. -- ********************* J Streger MS Office Master 2000 ed. MS Project White Belt 2003 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thank you Tom. :)
-- ********************* J Streger MS Office Master 2000 ed. MS Project White Belt 2003 "Tom Ogilvy" wrote: On way would be to declare a dummy variable as the same type. Then use lset to reset sub abc( b as TPETC_COLS mydum as TPETC_COLS ' work with b, never touch mydum ' now to reset lset b = mydum ' b is now reset End Sub If you have a fixed array of these variables and you want reset them all, then you can use erase sub abc( b(0 to 10) as TPETC_COLS ' work with b, never touch mydum ' now to reset all the type variables in the array erase b ' all variables in b are now reset End Sub -- Regards, Tom Ogilvy "J Streger" wrote: I have: Public Type TPETC_COLS Sort As Integer AStart As Integer RStart As Integer SStart As Integer RComplete As Integer SComplete As Integer End Type But in the middle of the code I want to ensure all values in the type are set to 0, I just want to know if there is an easier way to do this rather than declaring each one as 0. Thanks. -- ********************* J Streger MS Office Master 2000 ed. MS Project White Belt 2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Returning Values From a User-Defined Type | Excel Programming | |||
"User-defined type not defined" message in Excel | Excel Discussion (Misc queries) | |||
Workspace faux user-defined type not defined | Excel Programming | |||
User-defined data type; Error: Only User-defined types... | Excel Programming | |||
User Defined Type Structure - want it to be variable not numeric literal | Excel Programming |