userform system modal?

I designed a userform that will collect bits of info while working in other programs and be entered automatically into excel in the background. I want the form to be visible all the time but only get Windows focus when clicked. Help please, how to do it?

thank you DominicB for your quick responses!

Maybe I was not clear on what I am trying to ask. I want to have the form stay in front of all other windows, e.g. in front of IE so that I can copy and past bits of info from what I am reading to the different fields of the Excel form. All the info in the fields of forms will be entered as a record (row) in the excel file owns the form.

To do this without calling up excel, the form has to be on top when I switch to other programs (the form is really tiny, with 5 fields barely visible just to paste info into).

Thank you!

Originally Posted by dominicb

Good morning thank you!

...and welcome to the forum!

It's all in the way you call the userform to the screen, a simple :

UserForm1.Show vbModeless

should suffice (as long *** your userform is named UserForm1, obviously...)

HTH

DominicB