Consulting

Results 1 to 3 of 3

Thread: Solved: Userform scrollbar in frame

  1. #1
    Knowledge Base Approver
    The King of Overkill!
    VBAX Master
    Joined
    Jul 2004
    Location
    Rochester, NY
    Posts
    1,727
    Location

    Solved: Userform scrollbar in frame

    Hi Everyone,

    I have a userform which dynamically adds textboxes into a frame within the form. However, when I add more text boxes than will fit into the frame, vba still lets me do it, I just can't see them. I've changed the KeepScrollBarsVisible property to 3 (both), and changed the ScrollBars property to 1 (horizontal), and the scrollbar never works. What am I doing wrong? If need be I can attach an example workbook for this, but it seems pretty self-explanatory to me, and probably just a simple thing I forgot to do.

    Thanks!!!
    Matt

  2. #2
    Knowledge Base Approver
    The King of Overkill! VBAX Master
    Joined
    Jul 2004
    Location
    Rochester, NY
    Posts
    1,727
    Location
    OK, it was the scrollwidth property, I thought it was the increment in points that the frame would scroll when moved, but now I see that it's the width the scroll goes (my width was set at 400 something, and when I changed it manually to 1000 it worked. I'll just set this at runtime, should work fine!
    I couldn't figure out how to delete the message by editing it, so I just posted this instead
    Matt

  3. #3
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,897
    Location
    Quote Originally Posted by mvidas
    ... I couldn't figure out how to delete the message by editing it, so I just posted this instead
    Matt
    Nah, you shouldn't delete it anyway. This post will be good for when someone else has the same type of problem, they can read it and see your solution. I'll mark this thread as solved then.

Posting Permissions

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