I have a userform that allows me to add a new employee to a sheet, which adds some info to the sheet itself and creates a new sheet with that employees name on it. After all this process I try to setfocus back to the userform on the first text box, just by using myform.txtbox.setfocus yet it doesn't seem to work. My userform is modeless as well. Any help would be great.
also posted here: http://www.mrexcel.com/forum/excel-q...t-working.html
Sub AddEmployee()
Application.ScreenUpdating = False
clear
Sheets(curSheet).Select
MsgBox "Added Employee"
Application.ScreenUpdating = True
FirstName.SetFocus
End Sub
Bookmarks