Setting module-level object variables

**chrisanthny** · 04-26-2013, 05:59 PM

Maybe I'm using the wrong term here, but is it possible to set an object variable at the module or global level?

Specifically I simply wish to name a given cell (well, over 100 of them) and then be able to use that name in the module's Sub routines, for example,

Set name1 = Range("a1")

and then

If name1 = true Then
etc, etc

in a Sub procedure.

This works without a problem when I place it inside a Sub, but when I try it up at the beginning of a module, it tells me that it's an "invalid outside procedure".
I figure it'll be helpful if I don't have to declare these over and over again in each Sub procedure.

Thanks in advance
Chris

**crosservice** · 04-26-2013, 06:13 PM

If you declare the variable above/outside of the sub it should retain a value through any sub called in that module. So if you declare the variable, then immediately initialize/define in your first sub run it should work like you want. An example:

Please Login or Register  to view this content.

Other than that... I don't think so.

EDIT: Sorry, I get to typing code and that tab button becomes public enemy # 1...

**TMS** · 04-26-2013, 06:14 PM

You can't Set the value outside a procedure.

You can define (Dim) the variable before all the subroutines and functions but you need to give it a value in one of the procedures. Thus:

Please Login or Register  to view this content.

Regards, TMS

**chrisanthny** · 04-26-2013, 06:39 PM

Thank you TMS and crosservice. Works perfectly.

I just spent several fruitless hours trying to find the answer myself and you guys pop it up in less than 15 minutes. As a novice, it's very much appreciated.
Thank you kindly.

**TMS** · 04-26-2013, 08:16 PM

You're welcome. Thanks for the rep.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.