Results 1 to 16 of 16

.setfocus on userform not working

Threaded View

janderson055 .setfocus on userform not... 11-18-2012, 02:20 PM
cnodnarb Re: .setfocus on userform not... 11-18-2012, 02:34 PM
janderson055 Re: .setfocus on userform not... 11-18-2012, 02:38 PM
cnodnarb Re: .setfocus on userform not... 11-18-2012, 02:46 PM
janderson055 Re: .setfocus on userform not... 11-18-2012, 02:50 PM
cnodnarb Re: .setfocus on userform not... 11-18-2012, 02:52 PM
lipinsky Re: .setfocus on userform not... 03-15-2017, 03:17 PM
cnodnarb Re: .setfocus on userform not... 11-18-2012, 02:44 PM
Charles Re: .setfocus on userform not... 11-18-2012, 02:56 PM
janderson055 Re: .setfocus on userform not... 11-18-2012, 02:59 PM
Charles Re: .setfocus on userform not... 11-18-2012, 03:02 PM
janderson055 Re: .setfocus on userform not... 11-18-2012, 03:12 PM
Charles Re: .setfocus on userform not... 11-18-2012, 03:15 PM
abousetta Re: .setfocus on userform not... 11-18-2012, 03:47 PM
EssoExplJoe Re: .setfocus on userform not... 01-29-2017, 12:28 PM
FDibbins Re: .setfocus on userform not... 03-15-2017, 03:22 PM
  1. #1
    Registered User
    Join Date
    11-11-2012
    Location
    N/A
    MS-Off Ver
    Excel 2010
    Posts
    5

    .setfocus on userform not working

    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
    Last edited by janderson055; 11-18-2012 at 03:59 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1