Issue with checkboxes in userform

sramsay

Board Regular
Joined
Feb 19, 2015
Messages
96
Hopefully, I will explain this well enough for people to understand :)I have quite a complex userform. The issue I am facing is when clicking a checkbox in a different frame it is not ticking on the first click. It takes a second click.

I think the issue is there are a number of procedures that run when exiting any one frame. There is an exit frame procedure, followed by a procedure that runs when entering the new frame, and a few workbook cell changes that happen. It appears that the slight delay caused by these procedures running is the cause.

Furthermore, I have a procedure that runs on a click of the checkboxes and adding a breakpoint at this point I can see that it does not even trigger this procedure on the first click.

I have created a hacky workaround at the moment where the mouse pointer position is captured, and after the frame, entry procedure runs it moves the mouse back to this position and mimics a mouse click to tick the checkbox. As you can imagine, the mouse pointer jumping across the screen is not very end-user friendly.

Thanks in advance :-)
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Forum statistics

Threads
1,223,888
Messages
6,175,206
Members
452,618
Latest member
Tam84

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