String constants in Declaration section?

[Anonymous]

When trying to issue this command in the Declarations section of my
UserForm:

Public Const BLOCK_DIR="C:\Blocks"

I get this error:

Constants, fixed-length strings, arrays, and Declare statements not
allowed as Public members of an object module.

Why in the world can you not define a Public String Constant? and what is
the correct way to achieve this most logical approach I have tried.

[Anonymous]

Hi Matt,

I think you have to put your declaration in a module, not on a form.

Regards,

Arno van Eeuwen

Matt Slay wrote:

> When trying to issue this command in the Declarations section of my
> UserForm:
>
> Public Const BLOCK_DIR="C:\Blocks"
>
> I get this error:
>
> Constants, fixed-length strings, arrays, and Declare statements not
> allowed as Public members of an object module.
>
> Why in the world can you not define a Public String Constant? and what is
> the correct way to achieve this most logical approach I have tried.

[Anonymous]

The "correct" way is to expose your string constant via a property (yes,
forms can have them, too):

Public Property Get BlockDir() as String
BlockDir = BLOCK_DIR
End Property

I'll leave the "why" to someone else. 🙂

Mark Holder

Matt Slay wrote:

> When trying to issue this command in the Declarations section of my
> UserForm:
>
> Public Const BLOCK_DIR="C:\Blocks"
>
> I get this error:
>
> Constants, fixed-length strings, arrays, and Declare statements not
> allowed as Public members of an object module.
>
> Why in the world can you not define a Public String Constant? and what is
> the correct way to achieve this most logical approach I have tried.

[Anonymous]

Thanks Mark,

Very interesting remark.

Arno

Mark Holder wrote:

> The "correct" way is to expose your string constant via a property (yes,
> forms can have them, too):
>
> Public Property Get BlockDir() as String
> BlockDir = BLOCK_DIR
> End Property
>
> I'll leave the "why" to someone else. 🙂
>
> Mark Holder
>
> Matt Slay wrote:
>
> > When trying to issue this command in the Declarations section of my
> > UserForm:
> >
> > Public Const BLOCK_DIR="C:\Blocks"
> >
> > I get this error:
> >
> > Constants, fixed-length strings, arrays, and Declare statements not
> > allowed as Public members of an object module.
> >
> > Why in the world can you not define a Public String Constant? and what is
> > the correct way to achieve this most logical approach I have tried.

[Anonymous]

Arno:
Yes, it can be at all modules and form as long as it is in the declare
section.
Ken
Arno <106154.2325@compuserve.com> wrote in message
news:381CACFE.48D923CB@compuserve.com...
> Hi Matt,
>
> I think you have to put your declaration in a module, not on a form.
>
> Regards,
>
> Arno van Eeuwen
>
>
>
> Matt Slay wrote:
>
> > When trying to issue this command in the Declarations section of my
> > UserForm:
> >
> > Public Const BLOCK_DIR="C:\Blocks"
> >
> > I get this error:
> >
> > Constants, fixed-length strings, arrays, and Declare statements not
> > allowed as Public members of an object module.
> >
> > Why in the world can you not define a Public String Constant? and what
is
> > the correct way to achieve this most logical approach I have tried.
>
>
>