Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Form question

I am trying to use a form for the first time. I added it to my macro,
and it displays ok. When I exit from it I use Unload Me. However,
before it has cleared from the screen, a message box which comes up
later in the macro, appears over top of the form which I had closed.
Leaving both teh form and the msgbox on the screen

Can any tell me what I might be doing incorrectly?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Form question

Do you have
application.ScreenUpdating = False

in effect when you show the form?

If so, then that is probably the cause.

--
Regards,
Tom Ogilvy

wrote in message
...
I am trying to use a form for the first time. I added it to my macro,
and it displays ok. When I exit from it I use Unload Me. However,
before it has cleared from the screen, a message box which comes up
later in the macro, appears over top of the form which I had closed.
Leaving both teh form and the msgbox on the screen

Can any tell me what I might be doing incorrectly?



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Form question

Thanks, You're right, that was the problem

On Mon, 27 Oct 2003 21:18:36 -0500, "Tom Ogilvy"
wrote:

Do you have
application.ScreenUpdating = False

in effect when you show the form?

If so, then that is probably the cause.


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
Form design question. NDBC Excel Discussion (Misc queries) 0 June 29th 09 01:51 PM
Excel Form Question General Fear Excel Discussion (Misc queries) 3 December 8th 08 12:38 AM
Form question Rich Mogy Excel Discussion (Misc queries) 2 February 16th 07 06:14 PM
Creating a form question [email protected] Excel Discussion (Misc queries) 0 September 11th 05 10:48 PM
ser form question Gareth[_3_] Excel Programming 1 September 11th 03 09:27 PM


All times are GMT +1. The time now is 11:43 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"