I have a vba macro with the following structure:
- Open a Form A (vbModeless)
- In form, I have tons of controls. Two of them are command buttons.
- When I click on button 1 - another form (B) is displayed. This one is Modal.
- When I click on button 2 - another form (C) is displayed. This one is also Modal.
So my issue is that Forms A and B behave admirably.
But for some reason, Form C is brought up only sometimes when I process the click event on Button 2.
As I have played around with this, it is as if the when I click on parts of the button, I get a consisten response, but when I click on the top right quadrant (appoximately), nothing.
This should be really simple... and is driving me crazy.
Button is coded like this:
Private Sub CommandButton2_Click()
UserformC.Show
End Sub
I am not sure where to even start looking. I have put a break in the click event, and can confirm that I do not enter it each time I click on the button in question. When I do, my form is displayed just fine.
My only thought is that maybe there is some issue with having 2 modal forms? Long shot....
Any and all suggestions welcome![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
- Open a Form A (vbModeless)
- In form, I have tons of controls. Two of them are command buttons.
- When I click on button 1 - another form (B) is displayed. This one is Modal.
- When I click on button 2 - another form (C) is displayed. This one is also Modal.
So my issue is that Forms A and B behave admirably.
But for some reason, Form C is brought up only sometimes when I process the click event on Button 2.
As I have played around with this, it is as if the when I click on parts of the button, I get a consisten response, but when I click on the top right quadrant (appoximately), nothing.
This should be really simple... and is driving me crazy.
Button is coded like this:
Private Sub CommandButton2_Click()
UserformC.Show
End Sub
I am not sure where to even start looking. I have put a break in the click event, and can confirm that I do not enter it each time I click on the button in question. When I do, my form is displayed just fine.
My only thought is that maybe there is some issue with having 2 modal forms? Long shot....
Any and all suggestions welcome