Thread: How to refer a Variable across Workbooks ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
  
Posts: 1,080
Default 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.



Reply With QuoteReply With Quote