Passing value of variant

[Guest]

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'.

 

[Tom Ogilvy]

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.

 

[Guest]

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>'

 

[Tom Ogilvy]

Well, I didn't say anything about putting it (the declaration) in the code
on the form.

That just defeats the whole purpose.