Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How can I declare an Array in a form that will function as "Public". Those
arrays values can be updated for every modules that is called when this form runs.? I have an example: This array will be like: ReDim ErrorValue(1 To Len(myVal)) As String *I need it PUBLIC because those array values are going to be updated in each of the following functions: function check4code1() ¦ frmCheckCells.ErrorValue(k) ="Type 1" 'for check4code1 ¦ end function function check4code2() ¦ frmCheckCells.ErrorValue(k) ="Type 2" 'for check4code2 ¦ end function ¦.and More functions¦. if no error is found then ErrorValue will be Then, at the end of the process. The form will have a result like this Sub searchX() ¦ lbltxtErrorFound=ErrorValue(0) + ErrorValue(1) +ErrorValue(2)¦¦ ¦. End sub Can it be the best option ? Thanks Coco |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Basic question - modules and class modules - what's the difference? | Excel Programming | |||
When to code in sheet or userform modules and when to use modules | Excel Programming | |||
Declaring arrays | Excel Programming | |||
Class Modules vs Modules | Excel Programming | |||
Scope of variable includes all Form _and_ Code modules?? | Excel Programming |