Set focus to selected sheet when userform is open and using making use of RefEdit

Hey guys...

Strange how one realizes what one does not quite yet know unless an situation arises...

In attached file...after clicking image and opening userform
When then selecting a different sheet i.e Sheet1 and selecting the green range.How can I keep focus on sheet1 instead of it moving to the sheet originally opened on...i.e sheet2 when clicking option button or any other button on userform...

What about adding this piece of code in your existing one.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Or

In Userform Code

Please Login or Register  to view this content.

Hi Sixthsense

Thanks for your reply...The actual file is a Statistical Analytical Tool add-in
There are multiple other controls on each of the 15 userforms...
There could be multiple different sheets so the code must keep focus on the sheet selected while the userform is open...

I hope any of the below option will help you.

Please Login or Register  to view this content.

I suppose what i need is and event after RefEdit updates that activates the Parent sheet
Something like this...which does not work...

Please Login or Register  to view this content.

So Sixthsense

I ended up going with the following...Made use of your advice after noticing that the next step would be either 1 of 2 Option button selections...so code in both option Button controls

Please Login or Register  to view this content.

Glad you fixed it and thanks for the update