| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing variables?
I made my own little userform and I wanted to change a variable in "This
Workbook" when I hit the cancel button on the user form. Does this make sense? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
changing variables?
ThisWorkbook.Var = 17
as an example. Make sure Var is public. -- HTH Bob Phillips "Larry Sartoris" wrote in message ... I made my own little userform and I wanted to change a variable in "This Workbook" when I hit the cancel button on the user form. Does this make sense? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
changing variables?
I'm sure you saw this coming but... how do I know if its a public variable or
not? or how would I set it as a public variable "Bob Phillips" wrote: ThisWorkbook.Var = 17 as an example. Make sure Var is public. -- HTH Bob Phillips "Larry Sartoris" wrote in message ... I made my own little userform and I wanted to change a variable in "This Workbook" when I hit the cancel button on the user form. Does this make sense? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
changing variables?
I figured it out. Didn't know it had to be outside of the sub. And in main
module Thanks "Larry Sartoris" wrote: I'm sure you saw this coming but... how do I know if its a public variable or not? or how would I set it as a public variable "Bob Phillips" wrote: ThisWorkbook.Var = 17 as an example. Make sure Var is public. -- HTH Bob Phillips "Larry Sartoris" wrote in message ... I made my own little userform and I wanted to change a variable in "This Workbook" when I hit the cancel button on the user form. Does this make sense? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
changing variables?
"Larry Sartoris" wrote in message ... I figured it out. Even better. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| finding the results of changing 4 variables | Excel Discussion (Misc queries) | |||
| Copying functions without changing most variables in it | Excel Discussion (Misc queries) | |||
| Excel VBA - changing variables during a loop | Excel Programming | |||
| Changing the values of variables | Excel Programming | |||
| Changing objects on other Worksheets with Variables | Excel Programming | |||
Linear Mode
