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?

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?

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?

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?

changing variables?
 

"Larry Sartoris" wrote in message
...
I figured it out.

Even better.