Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to maintain variables value so when I return to a userform that
has already been used, it will already be filled out (as long as the user has previously visited it. I thought declaring the variables as public at the module level would make them visible in all subs but it is not working. In module 3 I have variables declared as public. In the sub, the variables are not declared because I want to use to publics but they seem to get over written when they are assigned a value. ie. MODULE 3 public v1 as string public v2 as string private sub MyButton_click() v1 = "myValue" v2 = "myValue" end sub The watch window shows <Out of context after values have been assigned inside the sub. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
variable scope | Excel Programming | |||
scope/ lifetime of variable | Excel Programming | |||
scope/ lifetime of variable | Excel Programming | |||
Variable Scope | Excel Programming | |||
Variable scope | Excel Programming |