Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 309
Default Modeless dialog box appears twice on screen???

I have a regular push button on top of my spreadsheet. When
the button is pressed, my userform gets loaded as a modeless
dialog box. Here's the code that loads it:

Sub Button1_Click()
UserForm1.Show vbModeless
End Sub


If the userform is already loaded and visible on the screen,
via a call from Button1_click(), should another Userform
instance get loaded if Button1 is pressed again??

I'm wondering if something is wrong, because I am now seeing
2 of the same Userform on my screen. I pressed the Button1
once, then twice, which caused 2 forms to appear.

Is this possibly a bug? Is it normal behavior??

thanx

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,452
Default Modeless dialog box appears twice on screen???

should another Userform instance get loaded if Button1 is pressed again

Doesn't with me.
Must be some relevant code there that you are not showing us.

RBS


"Robert Crandal" wrote in message
...
I have a regular push button on top of my spreadsheet. When
the button is pressed, my userform gets loaded as a modeless
dialog box. Here's the code that loads it:

Sub Button1_Click()
UserForm1.Show vbModeless
End Sub


If the userform is already loaded and visible on the screen, via a call
from Button1_click(), should another Userform
instance get loaded if Button1 is pressed again??

I'm wondering if something is wrong, because I am now seeing
2 of the same Userform on my screen. I pressed the Button1
once, then twice, which caused 2 forms to appear.

Is this possibly a bug? Is it normal behavior??

thanx


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
modeless dialog box acampbell Excel Programming 4 February 6th 07 02:28 PM
modeless dialog question Gary Keramidas Excel Programming 2 December 7th 06 08:33 AM
Excel add-in with modeless dialog ckb Excel Programming 0 March 6th 06 05:09 PM
'Unprotect' dialog box appears on every click danmahoney Excel Discussion (Misc queries) 0 February 15th 06 03:58 PM
Password screen to VBA appears with logging Off James L. Carr Excel Programming 0 December 8th 05 10:21 PM


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