randumhero
New Member
- Joined
- Feb 21, 2019
- Messages
- 3
Hello All,
First time poster here - maybe there will be a kind soul that can help me with this strange issue.
I was attempting to create a command button to display a userform for a project I'm working on, but was getting some strange behavior out of the button that I couldn't figure out. Instead of messing with it in the project file further, I just tried creating a basic active x command button in a blank worksheet to display a blank userform to see if the behavior was inherent to the project file I was working on... it wasn't - hence my question (see below).
I created a command button with this simple code behind it. This code is contained in the worksheet object.
Private Sub CommandButton1_click()
UserForm1.Show
End Sub
When I click the button the button duplicates itself to the upper left of the original button and disappears upon release of the mouse click. So, clearly it is not initiating the code above... To make matters even stranger, if I enlarge the size of the original button to be large enough that the duplicate overlaps. The duplicate does not disappear upon release; it remains. Further, I can then click this duplicate button and userform1 appears as originally intended.
I am thoroughly confused... any help would be much appreciated!
Thanks.
First time poster here - maybe there will be a kind soul that can help me with this strange issue.
I was attempting to create a command button to display a userform for a project I'm working on, but was getting some strange behavior out of the button that I couldn't figure out. Instead of messing with it in the project file further, I just tried creating a basic active x command button in a blank worksheet to display a blank userform to see if the behavior was inherent to the project file I was working on... it wasn't - hence my question (see below).
I created a command button with this simple code behind it. This code is contained in the worksheet object.
Private Sub CommandButton1_click()
UserForm1.Show
End Sub
When I click the button the button duplicates itself to the upper left of the original button and disappears upon release of the mouse click. So, clearly it is not initiating the code above... To make matters even stranger, if I enlarge the size of the original button to be large enough that the duplicate overlaps. The duplicate does not disappear upon release; it remains. Further, I can then click this duplicate button and userform1 appears as originally intended.
I am thoroughly confused... any help would be much appreciated!
Thanks.