Active X Command Button Misbehaving

[randumhero]

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.

 

[DanteAmor]

Welcome to the site!

Do you have any other code on the sheet or in the userform?

You could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.

 

[randumhero]

Hi Dante,

Thanks for your willingness to take a look at this. Please see link below... there is no confidential data as this is just a test file. I tried to make this as basic as possible in an effort to reduce variables that could be causing the problem.

Thanks again.

https://www.dropbox.com/s/m7qrmvlk807fyls/command button issue.xlsm?dl=0

 

[DanteAmor]

No, I dont have the problem. I press the button and it does not duplicate.

What version do you have of excel?

 

[Fluff]

I get a slight displacement when 1st clicking the button, but it still works. That said, ActiveX buttons are notoriously flaky.
I'd recommend replacing it with a forms control button, or a shape.