Modeless/vbModeless didn't work for me when I wanted to keep seeing a userform, but have the worksheet activated after I clicked on something on the userform.

AppActivate Application.Caption solved the issue :

• It leaves the userform on the screen.
• But it reactivates the sheet you see on the screen.

I understand Modeless/vbModeless gives you the possibility to work on the sheet or on the userform, but it does not reactivate the sheet.

AppActivate Application.Caption does that.