LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 81
Default Msgbox query

Hi,
Not sure about message boxes, but dont thing so, as vba stuff tends
not to be modeless
This is from steven bullens site:

"ModelessForm.zip (7 June 1999, 20k, 22004 downloads) Updated
There have been many, many requests for Excel to support modeless
userforms, which have been provided in Excel 2000. I recently
discovered what can only be described as a bug in Excel 97, which
results in a normal userform going modeless. Rob Bovey and Russell
Davis identified the cause as the EnableWindow API call. This update
now uses that API call to change a userform's modal state, and works
both for Excel 97 userforms and Excel 95 dialogsheets. Note, however,
that doing a cell drag-and-drop while the modeless form is visible
will cause Excel to GPF (thanks go to Dave Mullins for pointing this
out)! This trick does not emulate Excel 2000's real modeless forms in
terms of code being able to run side-by-side, and should be treated as
nothing more than a curiosity."


http://www.bmsltd.ie/Excel/Default.htm

So if your useing 2000 or later maybe use a userform?

I'm not sure what GPF stands for, but i guess it's not in any
shakespear!

Good Luck
Ross
 
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
Use MS Query to query data within the current work book Steve Kesler Excel Discussion (Misc queries) 0 August 6th 09 05:22 PM
Convert hard coded query criteria to Parameter Query Melanie[_2_] Excel Discussion (Misc queries) 0 July 15th 08 09:59 PM
Excel 2007 / MS Query - editing existing query to another sheet Hotpepperz Excel Discussion (Misc queries) 0 June 13th 08 06:53 PM
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? jocke Excel Discussion (Misc queries) 1 November 29th 05 01:44 PM
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? jocke Excel Discussion (Misc queries) 0 November 28th 05 06:37 PM


All times are GMT +1. The time now is 05:30 PM.

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

About Us

"It's about Microsoft Excel"