Hi Tom,

I've tried putting that statement in both the module and code on the form.
I have a watch on 'x' and when the code goes back to the module code the
watch value goes to '<out of context>'
--
Andrew


"Tom Ogilvy" wrote:

> use
> Public x as Variant
>
> in a general module - the type you get if you do Insert=>Module
>
> then it is visible to the entire project.
>
> --
> Regards,
> Tom Ogilvy
>
> "Andrew" <Andrew@discussions.microsoft.com> wrote in message
> news:C31EE628-E793-49A2-AA3F-7AA5D282A40E@microsoft.com...
> > Hi,
> >
> > I have a button on a userform. The userform is displayed after pressing a
> > button on a worksheet, called from a peice of code.
> >
> > UserForm1.Show
> >
> > Upon pressing the button a value is set (eg x = 1).
> >
> > How do I pass the value for x back to the original code? I have tried
> using
> >
> > 'Public x as Variant'.
> >
> > --
> > Andrew
>
>
>