Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 68
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to get a User Form to activate off a drop down menu Rcarper Excel Discussion (Misc queries) 2 October 2nd 09 02:04 PM
Activate a form ? dhstein Excel Discussion (Misc queries) 5 July 30th 09 02:51 AM
Cannot activate an Addin via the add-ins window in XL 2007 [email protected] Excel Discussion (Misc queries) 0 June 3rd 09 02:41 AM
How to activate (in the Project Explorer window) using VBA EagleOne Excel Discussion (Misc queries) 0 December 15th 06 02:26 AM
How to resize Data Form dialog window? Compucat Excel Worksheet Functions 1 June 8th 05 11:24 PM


All times are GMT +1. The time now is 11:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"