Using xl2000
SheetCount1 is a label on a userform.
Wondering if there is a simple way to change this:
So that it populates 3 of my userform labels; SheetCount1, SheetCount2, and SheetCount3.
Or will it require entirely different code with variables. Novice VBA'er here.
As always,
Thank you.
SheetCount1 is a label on a userform.
Wondering if there is a simple way to change this:
Code:
If WorksheetFunction.CountA(Sheet10.Range(Cells(1, 6), Cells(Rows.Count, 6).End(xlUp))) < 17 Then
SheetCount1 = "You will need one 1/3 sheet of paper (or larger) for each one of these."
End If
So that it populates 3 of my userform labels; SheetCount1, SheetCount2, and SheetCount3.
Or will it require entirely different code with variables. Novice VBA'er here.
As always,
Thank you.