Const declarations and accessibility

  • Thread starter Thread starter XP
  • Start date Start date
X

XP

Using Windows XP and Office 2007;

Is there a way to obtain the contents of a string constant from another
module where the other module in which the const lives is marked "Option
Private Module" and the const is declared as: Private Const myConst As String
= "MyString"?

If possible, could someone please post a generic example on how to do it?

If NOT marked private, is a module level Const automatically global, if not,
what is it?

Thanks for the clarifications!
 
Change 'Private Const' to 'Public Const'. That should still be visible
throughout the project even with Option Private Module

Regards,
Peter T
 

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

Global/Public 2
Assign a sound to a variable 19
Sound repeats unending until closing workbook 2
Weird Behaviour of Compiler Directives? 14
Const? 3
Macro to change macro or module level const that is calculated 1
variable declaration 7
Snag in invoice generator. How to change the "series" 5

Back
Top