Grouping over 100 Userform Labels

[Shea2288]

I have a userform that has hidden labels that will show up depending on the value of a TextBox. I have over 100 labels and my code is getting really cluttered.

There has to be a more efficient way of doing this. I'm fairly new to VB so any help would be appreciated. Thank you.

Please Login or Register  to view this content.

[Crooza]

Complete guess here and Untested but have you tried

Please Login or Register  to view this content.

[Shea2288]

Got a Syntax error when I tried. Thanks though.

Complete guess here and Untested but have you tried

Please Login or Register  to view this content.

[Shea2288]

Maybe I could add Labels to a Worksheet, group them and then have them inserted to the UserForm. It might work but I'll have to mess with the formatting.

[Crooza]

Try this then

Please Login or Register  to view this content.

I justly ran it on one of mine and it worked for me

[Shea2288]

Worked great, Thank you. It looks like I need to do some research and figure out what those commands do. I've never use For/Next. What does the Next t mean? +rep thanks again

Try this then

Please Login or Register  to view this content.

I justly ran it on one of mine and it worked for me

[Crooza]

Great. Glad it worked. You should mark this as solved (if not already).

Re the for next loop, it's probably one of the most used pieces of code. The for section established the start and finish counter, the next tells it to repeat the loop with the next available number in the loop. So in your example we started at 37 set the label to label37 undertook the various things we wanted then told it to progress to 38 and do the the whole thing again until it got to the last number

[Shea2288]

Thanks again for your help. Marking as solved.