Hi Guys
Here's a challenge ...
All searches warned me about RefEdit controls but somehow I managed to workaround the issues...so completed 15 userforms making use of them...Now all of a sudden I need to make use of 2 Refedits in my last userforms and am struggling to find a workaround for sheet activation...
Scenario in attached workbook as follows ... Form opens on sheet2 user selects range1 on Sheet1 via RefEdit1 ...
Now user clicks RefEdit2 ... automatically sheet2 is again the active sheet ...
How can I get Sheet1 which is RefEdit1 parent as the active sheet... I really don't want to have to incorporate a textbox workaround ...
In a previous thread I made use of the next in line command button to solve for 1 RefEdit ...What now?
Bookmarks