+ Reply to Thread
Results 1 to 5 of 5

Scrolling Userform with Headings

  1. #1
    Registered User
    Join Date
    08-01-2010
    Location
    Swindon, Wiltshire
    MS-Off Ver
    Excel 2003
    Posts
    30

    Question Scrolling Userform with Headings

    I have a multi-page user form that has, on one of the pages, a set of text boxes added dynamically when the form is opened. There can be up to 5 boxes across with a variable number down depending on the completed cells in the linked spreadsheet. At the top of each column of text boxes I want to display column headings.

    As the text boxes cannot all be seen at once I want to be able to scroll the page horizontally and vertically whilst keeping my column headings visible and correctly aligned when scrolling.

    Can anybody suggest a method to achieve the result I am looking for?

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Scrolling Userform with Headings

    What are the TextBoxes to be used for?

    Why not add a workbook?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    08-01-2010
    Location
    Swindon, Wiltshire
    MS-Off Ver
    Excel 2003
    Posts
    30

    Re: Scrolling Userform with Headings

    The text boxes contain contract clauses that are displayed depending on the contract type chosen. Where there are optional clauses option buttons are displayed to allow the user to select the one they want. I can't use a workbook as I would not be able to selectively display text and add the option buttons.

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Scrolling Userform with Headings

    Can't you use a ListBox with the required number of Columns

  5. #5
    Registered User
    Join Date
    08-01-2010
    Location
    Swindon, Wiltshire
    MS-Off Ver
    Excel 2003
    Posts
    30

    Re: Scrolling Userform with Headings

    No, that does not really give me what I need. In the end I decided to drop the headings until someone asks me if they can have them!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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