+ Reply to Thread
Results 1 to 3 of 3

User Form focus on textbox control?

Hybrid View

  1. 03-24-2014, 09:26 PM #1
    mc84excel
    mc84excel is offline
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    User Form focus on textbox control?

    I want to have a certain textbox focused when a UserForm is opened. How do I do this?
    *******************************************************

    HELP WANTED! (Links to Forum threads)
    Trying to create reusable code for Custom Events at Workbook (not Application) level

    *******************************************************
    Reply With QuoteRegister To Reply
  2. 03-24-2014, 10:59 PM #2
    jolivanes
    jolivanes is offline
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,692

    Re: User Form focus on textbox control?

    Like this you mean?

    Private Sub UserForm_Initialize()
    TextBox3.SetFocus
End Sub
    Reply With QuoteRegister To Reply
  3. 03-24-2014, 11:12 PM #3
    mc84excel
    mc84excel is offline
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: User Form focus on textbox control?

    Quote Originally Posted by jolivanes View Post
    Like this you mean?

    Private Sub UserForm_Initialize()
    TextBox3.SetFocus
End Sub
    I should have known!

    Thanks jolivanes, you've saved me a headache! +1
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. vba excel user form restrict input on user textbox
    By samz93 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-04-2013, 04:38 PM
  2. How do I move focus from User Form back to Word Doc?
    By sauerj in forum Word Programming / VBA / Macros
    Replies: 1
    Last Post: 11-10-2010, 09:32 AM
  3. Finding out which box on a user form has focus
    By duckboy1981 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-16-2009, 06:25 AM
  4. Enabling Edit>Paste when a textbox on a protected form has the focus.
    By ShortyTheDog in forum Excel General
    Replies: 4
    Last Post: 01-30-2007, 10:00 AM
  5. set focus on user form
    By jhahes in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2005, 05:05 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1