Variable from a sheet module in a class module in XL XP
 

Hello there,

how can I get the value of my variable "X" as defined in
a sheet module to be recognized and used in a class module
in the same vb project ?

Thank you in advance,

kind regards,

H.G. Lamy

Variable from a sheet module in a class module in XL XP
 

declare it as public and then use

myvar = sheet1.X

as an example.

--
Regards,
Tom Ogilvy

"hglamy" wrote in message
...
Hello there,

how can I get the value of my variable "X" as defined in
a sheet module to be recognized and used in a class module
in the same vb project ?

Thank you in advance,

kind regards,

H.G. Lamy

Variable from a sheet module in a class module in XL XP
 

Thank you, Tom,
I did not think of setting the sheet name ahead of the variable.

Regards,

H.G. Lamy

"Tom Ogilvy" schrieb im Newsbeitrag
...
declare it as public and then use

myvar = sheet1.X

as an example.

--
Regards,
Tom Ogilvy

"hglamy" wrote in message
...
Hello there,

how can I get the value of my variable "X" as defined in
a sheet module to be recognized and used in a class module
in the same vb project ?

Thank you in advance,

kind regards,

H.G. Lamy