ThisWorkbook.Var = 17

as an example.

Make sure Var is public.

--
HTH

Bob Phillips

"Larry Sartoris" <LarrySartoris@discussions.microsoft.com> wrote in message
news:D3BC9C6D-248D-4ECD-A1F5-798A15054E66@microsoft.com...
> 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?