Having UserForm in top on other opened windows

[jaryszek]

Hi Guys,

i found very interesting code from RobDog888 here:

http://www.vbforums.com/showthread.p...ughout-Windows

It is working like a charm but when i am opening chrome or another browser my userform is not top one but i have to once again click Excel to acticate userform as top one.
It is possible to do this automatically somehow to not activing all the time Excel app?

Can anybody help?

Jacek

[Andy Pope]

To keep the user form on top of other application will require API to set window position.

https://www.extendoffice.com/documen...ow-on-top.html


I see the example already set the userform to top.
Sound like you want the userform to take focus when the users switches windows. If so I would imagine that would get very annoying very quickly.

[jaryszek]

Thank you Andy very much!

Hmm maybe you have right. But this will be the timer so i want to give possibility user to measure their working time and not hide userform.

Thank you for link, i will try use it!

Jacek