+ Reply to Thread
Results 1 to 3 of 3

How can i control sheet (up and down) using scrollbar inside userform?

  1. #1
    Registered User
    Join Date
    03-07-2017
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    182

    How can i control sheet (up and down) using scrollbar inside userform?

    I have a userform and planning to put a scrollbar to control the sheet1 up and down while the userform is active.

    Thank you

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: How can i control sheet (up and down) using scrollbar inside userform?

    Scrollbar named 'sb'

    Please Login or Register  to view this content.
    Note the max number of rows is 32767 (The limit of an Integer datatype which is the declared type for the Max property of the scrollbar).

  3. #3
    Registered User
    Join Date
    03-07-2017
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    182

    Re: How can i control sheet (up and down) using scrollbar inside userform?

    Perfect! Thanks for your inputs!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Any way to avoid hardcoding control name inside the control event procedure?
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-24-2015, 07:50 PM
  2. Displaying in Treeview with scrollbar control
    By ongyl in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-12-2013, 03:03 AM
  3. [SOLVED] show jpeg picture inside a userform image control box
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 31
    Last Post: 07-29-2013, 03:44 PM
  4. [SOLVED] Excel 2007 : Formatting a Form Control Scrollbar
    By HangMan in forum Excel General
    Replies: 5
    Last Post: 07-09-2012, 01:12 PM
  5. userform is large.....how to use scrollbar of userform to show all of the userform
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-05-2010, 04:11 PM
  6. Userform Scrollbar to control cell
    By Mike T in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2009, 09:46 AM
  7. control worksheet scrollbar using userform
    By stoey in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-11-2008, 02:43 AM
  8. Can't Filter Sheet from inside a UserForm
    By Mike in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-11-2005, 07:06 PM

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