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.

Hi,

Please Login or Register  to view this content.

Not that it matters but note the mis-spelling of 'building'

Hi,

Simply create a 1-10 loop as the first thing the Go button does, and first make all the text boxes and labels invisible.

Hi,

Yes, that's exactly what I meant since you indicated the trigger is the Go button and not the movement of the spin button. Specifically

Please Login or Register  to view this content.