Closed Thread
Results 1 to 2 of 2

Scroll set when entering a Textbox

  1. #1
    Registered User
    Join Date
    09-20-2012
    Location
    Peoria, Arizona
    MS-Off Ver
    Excel 2013
    Posts
    39

    Scroll set when entering a Textbox

    I have one that is really stumping me. I have a userform with multiple textboxs so I have activated the scrollbars to the side. I have set up buttons right under the textboxes that automatically enter information into the textboxes when clicked. I have activated tab behaviors to tab from the top box down to the bottom box. The problem is that as I tab to the boxes lower on the scroll, the buttons underneath them are not visible. So, I am trying to create a macro to set the scroll function when I tab to the next box. I cannot figure out how to set the ScrollTop when activating the textbox. Any suggestions?

    Private Sub TextBox49_Activate()
    MultiPage1.Page31.ScrollTop = 800
    End Sub

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Scroll set when entering a Textbox

    Welcome to the Forum, unfortunately this is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Make a Textbox ready-only but able to scroll down text
    By rtaboada in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-19-2011, 06:46 PM
  2. Scroll textbox if the adjacent is scrolled
    By fredpox in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-27-2010, 04:41 PM
  3. Entering a date into a userform textbox
    By jerseyguy1996 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2010, 12:28 PM
  4. Scroll bar in Textbox (Autoshape) on worksheet
    By karan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-04-2009, 02:12 PM
  5. Entering data from textbox in VB
    By B_Taylor in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-04-2008, 04:57 AM
  6. Refresh textbox to reflect scroll bars if appropriate
    By Jim May in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2006, 04:10 PM
  7. What's the secret on scroll bars in textbox
    By excelnut1954 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-15-2006, 05:15 PM
  8. Entering a date in a textbox
    By johncassell in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-25-2005, 10:05 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1