Bring open userform to front

[miami2k]

Dear All,

I have an issue with my project. When I work with more than one Excel file at the same time, it happens sometimes that the main userform is open in front of an Excel file that is not the one on which it is based.
I added this code under the sub of first combobox change:

Set SCFI = ThisWorkbook
SCFI.Activate

This brings the right Excel file in front but unfortunately the userform goes behind.
I cannot use the command myuserform Show because it goes in a sort of loop.
I've read something about a function (API Code?) but I was looking for something simpler.
Any suggestion?
Thank you

miami2k

 

[decadence]

If you are using a User Form then you can just use the below code when calling the User Form to open and it stays open on top of all Excel Files that you open

    UserForm1.Show (vbModeless) ' Change UserForm1 to whatever your User Form is