View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
XP XP is offline
external usenet poster
 
Posts: 389
Default Const declarations and accessibility

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!