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?