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

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Forum statistics

Threads
1,223,880
Messages
6,175,153
Members
452,615
Latest member
bogeys2birdies

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