variable

S

sarndt

If i have a variable that I want to set and use from TheWorkbook, a number of
difference worksheets, a module, and a class module, which General
Declarative section do I put it in, and do I reference it as a Public
Variable or something else.

Thanks

Steve
 
D

Dave Peterson

I would insert a new module (Insert|Module type) and use:

Public MyVar as Long 'or double or ...
 
S

sarndt

Dave...

Why would you put it in a new module instead of the existing module Module1?
 
D

Dave Peterson

It's not necessary. I just wanted to make sure that you used a General module
and that was the best way I knew to describe what I wanted.

But I will (usually, but not always), put all my public variables in a dedicated
module -- maybe some initialization routines, too.

But that's just for organizational purposes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Public variable 7
class module variable declaration issue 4
Public Variables, Class Modules and Standard Modules 2
UserForm Pointers & Class Modules 3
Private vs Public Class Modules 11
Passing a variable from sheet code to a module 2
Accessing Public variable in different modules 6
How/where to declare variables shared by objects of a class? 3

Top