Activating workbook from userform

[HighAndWilder]

Hi

I am loading a userform from workbook1 which contains code behind a command button to select another workbook (workbook2)
and load it.

I want the active workbook to be workbook1 but despite activating this workbook the active workbook remains workbook2

If after loading workbook2 I use msgbox to display a name of the workbook, or anything at all in fact, the code to activate workbook1 works.

I have experiencd this before.

I'd like the form to sit on top of the active workbook. Changing the active workbook from the form does not do this.

Any clues anybody?

Thanks

 

[Yongle]

This works for me
- leaving Workbook1 as the active workbook which is visible below the UserForm

Private Sub CommandButton1_Click()
    Dim wb1 As Workbook: Set wb1 = ThisWorkbook
    Dim wb2 As Workbook: Set wb2 = Workbooks.Open("c:\test\ANYfILE.xlsm")
    wb1.Activate 
End Sub

If above does not help you solve the issue...
Which version of Excel are you using?
What are you doing different?

 

[HighAndWilder]

This works for me
- leaving Workbook1 as the active workbook which is visible below the UserForm

Private Sub CommandButton1_Click()
    Dim wb1 As Workbook: Set wb1 = ThisWorkbook
    Dim wb2 As Workbook: Set wb2 = Workbooks.Open("c:\test\ANYfILE.xlsm")
    wb1.Activate 
End Sub

If above does not help you solve the issue...
Which version of Excel are you using?
What are you doing different?

Activating a workbook other than the one that the userform is in works fine but I want the userform to still be displayed on top of the active sheet.

It should be so simple as I imagine that it is a common requirement.

 

[HighAndWilder]

Got there in the end.

https://www.jkp-ads.com/articles/keepuserformontop02.asp

Not quite as simple as I think that it should be. Prior to 2013 Excel kept the userform on top.