Two Clicks Needed for ActiveX Controls

FlyFishn4Bass

New Member
Joined
Mar 22, 2022
Messages
2
Office Version
  1. 365
Platform
  1. Windows
I have several ActiveX controls on my worksheet (not a userform). For a while everything seemed to work just fine, however, recently (in the past few months) I've needed to push the controls twice (not a dbl-click, but 2 separate clicks) to get the control to function. In another thread there was a suggestion to use the "GotFocus" events, however, I'm having trouble with OptionButtons, which don't have such an event. I'm experiencing this on multiple worksheets, so I don't think it's anything in my code (unless I'm repeating a mistake in all my spreadsheets, but I don't think so). I also know it isn't system response (timing) issue. Sometimes I will wait 3 or 4 seconds before pushing the 2nd click, sometimes 3 or 4 minutes. The first click just seems to evaporate ... but the 2nd click always gets through.

Any thoughts on what might be going on?

I know I can backup and use Form Controls instead of ActiveX, but that dramatically changes appears and implementation.

Thanks in advance for any advice or hints.
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Forum statistics

Threads
1,214,965
Messages
6,122,500
Members
449,090
Latest member
RandomExceller01

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top