ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to close forms opened from other workbooks...? (https://www.excelbanter.com/excel-programming/331553-how-close-forms-opened-other-workbooks.html)

Andrew

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




All times are GMT +1. The time now is 12:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com