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

modeless userform 4
Hide Userform modeless 7
Special modeless "Userform" object.... 3
Focus Event 4
Set focus on controls of modeless form 4
Can you check a show modal property 6
VBmodeless user form errant behaviour 3
Modeless dialog box appears twice on screen??? 1

Top