FlyFishn4Bass
New Member
- Joined
- Mar 22, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- 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.
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.