"Doug Glancy" wrote ...
[i]
How do I delcare a varible as
being global?

Normally, declare a public variable at the begin of a module, above
any subroutines.

The same as for any module, my advice would be to declare a Private
(module-level) variable and make it available externally using a
Property Get (optionally a Property Let/Set) of scope Friend or Public
as appropriate e.g.

Private m_strName As String

Friend Property Get Name() As String
Name = m_strName
End Property

Jamie.

--