Public Variables in Module1

Tech-Archive recommends: Speed Up your PC by fixing your registry



Very simple question.

I have a project with multiple forms and a Module1. In Module1 I have
written the connectionstring:

Module Module1
Public connectionstring = "provider=Microsoft.Jet.OLEDB.4.0;data source=" +
Application.StartupPath + "\mydatabase.mdb;"

End Module

In Form I am using this "connectionstring" form.

Ok..now here is the question. How come this variable is available
(automatically) in other forms even though I haven't imported Module1 in
those forms?

Thank you in advance.


.



Relevant Pages

  • Re: Assigning a module to a button macro
    ... Gord Dibben MS Excel MVP ... >How do I assign a procedure in module1 to a custom button? ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: Why wont it work?
    ... Put it back in Module1. ... Sub XXXXX ... (It follows the word Sub.) ... Prev by Date: ...
    (microsoft.public.excel)