Object Module Constants Scope

  • Thread starter Thread starter griff
  • Start date Start date
G

griff

I hope my terminology is correct:

I have some object modules (button clicks) in which I want to some
project wide constants - which will be used in many places.

What is the suggested tidy way to do this without declaring the
constants twice in the object module and code module.
 
Declare them as Public variables in a standard code module.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

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

How to change add-in object from within worksheet module. 3
Option Private Module (for Object Modules) 5
Declare a Public Array 5
Possible scoping problem 8
Set Global Variable Inside Object Module 3
Public Range Constant - how do I? 13
Defining public/global variables in more than one place 1
Functions - visibility 3

Back
Top