When I posted, I only saw the post asking about constants - I wasn't in
threaded mode - so I thought it was a standalone question.
--
Regards,
Tom Ogilvy
"Bob Phillips" wrote in message
...
In this instance, it should be Public as it is being referred to in
another
module, the form class. But as Tom shows, it can be defined as just Const
if
only used in that module.
--
HTH
RP
"Chuckles123" wrote in message
...
I can see that I have some distance to go to proceed up the learning
curve.
Tom, I assume you meant "Public Const sSTRING = "ABCD". And doesn't
the code need a STRING1 and a STRING2?
Chuckles123
--
Chuckles123
------------------------------------------------------------------------
Chuckles123's Profile:
http://www.excelforum.com/member.php...o&userid=14948
View this thread:
http://www.excelforum.com/showthread...hreadid=268057