Hi All, I have a multipage form in my workbook that, on the Activate event, opens to the first page with:
userform1.multipage1.value=0
This is working fine. However, on the second page I have a date field that, when entered, opens up a simple date form, with an OK and Cancel button. If either of these are pressed, I want the form to close and the focus to remain on the second page. I've tried various iterations of this code, but none of them work. The focus always goes back to the first page. 
Private Sub cmdCancel_Click()
    UserForm1.txtDate = ""
    frmTxDate.Hide
    UserForm1.txtSW.SetFocus ' this text box is in the second page of the multiform.
    UserForm1.Multipage1.Value = 1
End Sub
...any ideas?

Note: This was originally posted here but got no response: http://www.mrexcel.com/forum/excel-q...set-focus.html