Passing a private variable to another module

**Andy Pope** · 11-26-2008, 12:04 PM

Are you sure about where each code sample is?

Are you saying your class exposes click events?

I thought I had posted a reply, maybe I forgot to submit.

You can declare a public variable in the class or a private variable with get/let properties.

In your main code you will need to assign the value to the property before executing the function that uses it other wise the value will be zero

**maacmaac** · 11-26-2008, 01:25 PM

Andy -

Sorry, you lost me in your comments. I'm not sure what the "get/let" properties are nor do I know where to assign the value. The whole assigning variables and letting other procedures use these variables is somewhat new to me. Realistically, I would really like to declare "j" as a private variable and then pass the value to the function that needs it. I have attached a copy of the spreadsheet so you can see where each code is stored. HTH. Thanks again for your comments.

**Kenneth Hobson** · 11-26-2008, 01:43 PM

As I said, if you will copy the Public to the top of both the sheet and the Module, it will work. Or, Dim j in the module where it was not defined as Public.

While you have few rows and J as integer will work, it is generally a good practice to dim variables that reference row numbers as Long.

**Leith Ross** · 11-26-2008, 02:03 PM

Hello maacmaac,

The attached file has the corrections. The row number "j' is now stored as a public variable "LineNumber" in the class module. Property Let assigns the value and Property Get returns the value.

Sincerely,
Leith Ross