Results 1 to 7 of 7

UserForm Knowledge Needed to make labels visible and unvisble based on event change

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-20-2011
    Location
    United States, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    295

    UserForm Knowledge Needed to make labels visible and unvisble based on event change

    Hello

    I need some help with getting my userform to work correctly. I am new to this so please excuse my ignorance.

    If you look at the attached sample spreadsheet, I have a userform called "frmBuildings" created with 11 labels, 1 scroll bar, and 2 commands. SHEET1 contains the macro to call the userform.

    The Scroll bar changes the values within "tbxBuidlingcount." I think I have them linked together correctly as it appears they are working they way they should.

    My goal is to have the user use the scroll bar to select how many "buildings" there are, then once they hit the command button "GO", it will make visible that many (meaning the value in text box "tbxBuidlingcount") labels/text boxes.

    This makes more sense once you look at the userform.

    I know this is probably easy...I jsut cant find anywhere on the interenet that shows me how to do that.

    Thanks in advance.
    Attached Files Attached Files
    Last edited by clemsoncooz; 01-20-2012 at 08:57 AM.

Thread Information

Users Browsing this Thread

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

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