Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Multipage properties scrollbar (Excel 2002)

    Hi all,

    I have a userform with a multipage control, I would like to be able to scroll the multipage because in the case that I need it I can't figure out how to make it scroll. Can someone point me to a thread to help me get started.

    thanks,
    Darryl.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multipage properties scrollbar (Excel 2002)

    Each page of a multipage control has a ScrollBars property. By default, it is set to 0 - fmScrollBarsNone, but you can set it to 1 - fmScrollBarsHorizontal, 2 - fmScrollBarsVertical or 3 - fmScrollBarsBoth.
    The scroll bar(s) won't do anything until you set the ScrollHeight (for a vertical scrollbar) and/or ScrollWidth (for a horizontal scrollbar) property. These properties specify the distance (in points, where 72 points = 1 inch) over which the scrollbar can scroll.

  3. #3
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Multipage properties scrollbar (Excel 2002)

    Thanks Hans!

Posting Permissions

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