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
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