• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 344
  • Last Modified:

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
0
Saqib Husain, Syed
Asked:
Saqib Husain, Syed
  • 2
  • 2
1 Solution
 
Martin LissOlder than dirtCommented:
See this similar thread. It doesn't look like there's a way to do it.
0
 
Saqib Husain, SyedEngineerAuthor Commented:
I found this and it works

    AppActivate Application.Caption
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.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now