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?

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?

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" <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?
>
>
>

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" <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?
> >
> >
> >

"Larry Sartoris" <LarrySartoris@discussions.microsoft.com> wrote in message
news:3CD277AA-46DD-429E-95CD-63C6D00162EF@microsoft.com...
> I figured it out.

Even better.