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?