Results 1 to 10 of 13

Thread: A Neat "Go To Sheet" Selector

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    659
    Rep Power
    13
    Quote Originally Posted by MrBlackd View Post
    To call the form:
    Code:
    Sub CallGoToSheetSelector()
      GoToSheetSelectorUserForm.Show
    End Sub
    To center form and to focus in textbox so as to start typing immediately:
    Code:
    Private Sub UserForm_Activate()
        
    With Me
      .StartUpPosition = 0
      .Left = Application.Left + (0.5 * Application.Width) - (0.5 * .Width)
      .Top = Application.Top + (0.5 * Application.Height) - (0.5 * .Height)
    End With
       
    Me.TextBox1.SetFocus
       
    End Sub
    Friendly greetings.
    Who are you directing your comments to?

  2. #2
    Member
    Join Date
    Jul 2013
    Posts
    40
    Rep Power
    0
    In the version that I had downloaded setfocus to textbox was not there, probably you have included it in the updated version but I hadn't seen it, that is why I posted...
    My mistake, please delete my post...
    Keep in mind all vba I know has been googled...

Similar Threads

  1. VBA Versions of my "Get Field" and "Get Reverse Field" formulas
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 4
    Last Post: 06-02-2017, 06:15 PM
  2. Reversing a "First Middle Last" Name to "Last, First Middle" Name Format
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 5
    Last Post: 01-06-2014, 10:04 PM
  3. Replies: 4
    Last Post: 09-09-2013, 05:13 PM
  4. Replies: 5
    Last Post: 04-18-2013, 02:30 AM
  5. Ordinal Suffix (i.e., "st", "nd", "rd" and "th")
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 0
    Last Post: 03-20-2012, 03:46 AM

Posting Permissions

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