Clicking "Forms Control" Button (sometimes) does not execute macro but instead clicks into Edit the Button Text mode

Hi Experts,

In an Excel 2010 worksheet, I have a Forms Control Button that when clicked * sometimes * places the cursor at the beginning of the Text in the Button instead of executing the underlying macro. Clicking off the Button into a worksheet cell and then clicking the Button again will then execute the macro. Other times, the first click will execute the macro as intended. The macro loads a User Form.

Can anyone advise how to fix this behavior?

Jeffrey SmithOwnerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Saurabh Singh TeotiaCommented:

If you click on a form button right one that should select the form button otherwise it should run the macro and it will do what you are looking for..

Alternatively you can insert button from activex as that will get selected only on design mode and once you insert the same you can say view code and call your userform from their which will do what you are looking for..

Martin LissOlder than dirtCommented:
Can you post your workbook, or a sanitized sample?
Jeffrey SmithOwnerAuthor Commented:
Hi Saurabh & Martin,  

Thanks for posting.  

Saurabh - I understand right-clicking the button will allow me to modify the button, but what is happening (again, only sometimes) is that when I left-click the Button it is as if I had right-clicked it, and then chosen "Edit Text" (the cursor is positioned in front of the Button text and is blinking).  I'm trying to stay away from ActiveX Controls due to the problems they sometimes have ...

Martin - it will take me some time to finish putting a workbook together ... however, as I was starting down that path, I made a copy of the ws in question, and started clicking on the newly created button a dozen times and in call cases, it executed the macro as it should.  That led me to think that there might have been something glitchy about the button itself so I deleted it and created a new one in my original file.   Tested that a dozen times and it seems to be working ok, too, (at least for now).

Let me see if this new button solves my issue and I'll come back and update this topic.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Jeffrey SmithOwnerAuthor Commented:
Sorry, I didn't get back here to close this out.  Replacing the button seemed to do the trick. Guess I solved this myself, so I'll close this now.

Thanks, guys.
Jeffrey SmithOwnerAuthor Commented:
Oops, guess it's already in Auto-Close mode.
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.