Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Object Module Constants Scope


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.

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default Object Module Constants Scope

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)

"griff" wrote in message
...

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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy Sheet Object Module Filo Excel Programming 2 May 23rd 07 04:26 AM
Pass worksheet object name to a class module [email protected] Excel Programming 1 May 9th 07 12:48 PM
Declaring array constants at module level Microsoft Forum Excel Programming 2 January 24th 05 06:31 PM
variable scoping - constants going out of scope - circular references Masa Ito Excel Programming 1 October 3rd 04 02:24 PM
Class Module Scope Trent Argante[_2_] Excel Programming 2 January 6th 04 03:01 PM


All times are GMT +1. The time now is 05:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"