av8tordude
10-26-2019, 04:03 AM
I have a userform that has 10 labels that are named with the leading text lblM_ (see below). I want to check if any of these labels are visible. If any of the labels below are visible then "Do Stuff" else "Do Other Stuff"
I kindly ask for assistance with a vba code that can accomplish this task.
I posted similar posting here: https://www.mrexcel.com/forum/excel-questions/1113394-loop-check-if-visible.html
lblM_tbxSch800
lblM_tbxSch900
lblM_tbxSch1000
lblM_tbxSch1100
lblM_tbxSch1200
lblM_tbxSch1300
lblM_tbxSch1400
lblM_tbxSch1500
lblM_tbxSch1600
lblM_tbxSchNotes
I kindly ask for assistance with a vba code that can accomplish this task.
I posted similar posting here: https://www.mrexcel.com/forum/excel-questions/1113394-loop-check-if-visible.html
lblM_tbxSch800
lblM_tbxSch900
lblM_tbxSch1000
lblM_tbxSch1100
lblM_tbxSch1200
lblM_tbxSch1300
lblM_tbxSch1400
lblM_tbxSch1500
lblM_tbxSch1600
lblM_tbxSchNotes