| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating UDF by Class Module (Leo)? | Excel Discussion (Misc queries) | |||
| CLASS MODULE & SIMPLE MODULE | Excel Discussion (Misc queries) | |||
| Pass a variable from a class module | Excel Programming | |||
| please give an example of a class module. | Excel Programming | |||
| how to declare a class module | Excel Programming | |||
![hglamy[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
