ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to keep window + form activate together (https://www.excelbanter.com/excel-programming/272522-how-keep-window-form-activate-together.html)

John Brash

How to keep window + form activate together
 
Hi,

How to keep running macros so that these two operate
together and can access each another by controls like
buttons?

1. A window as main interface
2. A form as index

Thanks.

Bill Lunney

How to keep window + form activate together
 
If you have Excel 2000 or above display a modeless form by using something
like:

frmTest.Show vbModeless


http://www.billlunney.com/Excel/FAQ/...?ExcelFAQID=51


--

Regards,


Bill Lunney
www.billlunney.com

"John Brash" wrote in message
...
Hi,

How to keep running macros so that these two operate
together and can access each another by controls like
buttons?

1. A window as main interface
2. A form as index

Thanks.





All times are GMT +1. The time now is 08:09 AM.

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