Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to close forms opened from other workbooks...?
I have a form that is loaded(show) from Personal.xls.
Other workbooks can then be opened. Q. how is it possible to check if the form (Main.FRM) is open and close it or reference a listbox item if it is open. Is there a way of: If Userforms("Main") then ThisTextbox.text=Workbooks("Personal").Main.TextBo x1.Text end if Thanks for any Help. Andrew |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
History of Workbooks opened | Excel Worksheet Functions | |||
Book1 default - does not close once another file is opened | New Users to Excel | |||
Macro to save & close all opened files | Excel Discussion (Misc queries) | |||
why do all excel worksheets/workbooks close when I close one? | Excel Discussion (Misc queries) | |||
Forms.Close | Excel Programming |