How to refer a Variable across Workbooks ?
 

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.

How to refer a Variable across Workbooks ?
 

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

--

Vasant

"Prabhu Dev" wrote in message
...
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.