How to refer a Variable across Workbooks ?

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.
 
V

Vasant Nanavati

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