Change Label Top on UserForm based on Count

[ker9]

I am using a UserForm to do a validation of what might be incomplete on a worksheet. I am trying to get the different labels to appear in the appropriate next location and trying to use a count to do it. So that if label 1 visible and label 3 visible, there is no blank space between them where label 2 would be if it needed to be visible. Short piece of not working code below - there is a potential for 6 labels.

Please Login or Register  to view this content.

[Andy Pope]

Do you really need to use labels? How about using a list box then you simply additem if caption text is to be displayed.

Currently your code only has lTop set once and not incremented if a label contains text.

[ker9]

Hi, Andy
Thank you for your response. I never thought to use a list. That might be a better idea.
I did finally get my code to work - see below

Please Login or Register  to view this content.