How to refer a Variable across Workbooks ?

  • Thread starter Thread starter Prabhu Dev
  • Start date Start date
P

Prabhu Dev

Hi,

I am using Excel-97. I need to refer to a Public variable
in UserForm1 in WorkBook1 from WorkBook2. How can I ?

Public bLoginStatus as Boolean

Any help is appreciated.

Thank you.
 
I believe the only way would be to set a reference from Workbook2 to
Workbook1 using Tools | References in the VBE.
 
Back
Top