Modeless userform to activate cells

I have this userform which I show modeless whenever I have sheet1 active. I want to show the userform but keep the activecell active.

With the attached setup whenever the userform is shown I have to click on the cell to be able to move around the worksheet using the keyboard.
ModelessForm.xlsm
LVL 43
Saqib Husain, SyedEngineerAsked:
Who is Participating?
 
Saqib Husain, SyedEngineerAuthor Commented:
I found this and it works

    AppActivate Application.Caption
0
 
Martin LissOlder than dirtCommented:
See this similar thread. It doesn't look like there's a way to do it.
0
 
Martin LissOlder than dirtCommented:
Thanks for letting me know.
0
 
Saqib Husain, SyedEngineerAuthor Commented:
Googled to the solution
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.