| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help should show how to refer to other workbooks | Excel Discussion (Misc queries) | |||
| Using INDIRECT to refer to different workbooks | Excel Worksheet Functions | |||
| variable to refer to "this worksheet"? | Excel Worksheet Functions | |||
| Variable Link to Workbooks | Excel Worksheet Functions | |||
| Refer to Combo-box using a part + variable | Excel Programming | |||
Linear Mode
