Prev: control arrays
Next: Hiding rows where text not entered to right of colums A and B
From: Robert Crandal on 23 Dec 2009 04:25
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

From: RB Smissaert on 23 Dec 2009 08:14
> 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" <nobody(a)gmail.com> wrote in message
news:imlYm.14005$eH1.5044(a)newsfe16.iad...
>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
>

 | 
Pages: 1
Prev: control arrays
Next: Hiding rows where text not entered to right of colums A and B