Hello !

I know there is a way to declare a varialble that can be
declared in the heading of the module so that the
variable can be set and used as "constant" as long as the
module is open does anyone know how.

PSH

If you need a variable:

PUBLIC NameOfYourVariable AS TypeOfYourVariable

If you want a constant:

PUBLIC CONST NameOfYOurConstant AS TypeOfYourConstant = ValueOfYourConstant

"PSH" <(E-Mail Removed)> wrote in message
news:03ff01c34602$39e51820$(E-Mail Removed)...
> Hello !
>
> I know there is a way to declare a varialble that can be
> declared in the heading of the module so that the
> variable can be set and used as "constant" as long as the
> module is open does anyone know how.
>
> PSH

Put those right below Option Explicit.

--
Chris

Please respond to newsgroups, as I
don't check this address very often.
"Scott McDaniel" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> If you need a variable:
>
> PUBLIC NameOfYourVariable AS TypeOfYourVariable
>
> If you want a constant:
>
> PUBLIC CONST NameOfYOurConstant AS TypeOfYourConstant =
ValueOfYourConstant
>
> "PSH" <(E-Mail Removed)> wrote in message
> news:03ff01c34602$39e51820$(E-Mail Removed)...
> > Hello !
> >
> > I know there is a way to declare a varialble that can be
> > declared in the heading of the module so that the
> > variable can be set and used as "constant" as long as the
> > module is open does anyone know how.
> >
> > PSH
>
>