Modeless Userform

R

Roger

Is ther a way to return focus back to the worksheet automatically after a
user hase clicked a button on a permanently displayed modeless userform
 
P

Peter T

A simple way the usually works, called in a modeless userform -

AppActivate Application.Caption

Regards,
Peter T
 
R

Roger

Peter - thanks - worked a treat


--
Roger


Peter T said:
A simple way the usually works, called in a modeless userform -

AppActivate Application.Caption

Regards,
Peter T
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set focus (and select text) on a text box on a modeless userform? 0
modeless userform 4
Set focus on controls of modeless form 4
Special modeless "Userform" object.... 3
Optionbutton Not working 3
I figured out the issue thank you. 0
Modeless dialog box appears twice on screen??? 1
"Coult not find specified object" and "Path-File access error" messages 3

Top