Show filter subtotal to userform Label

[Av8tordude]

I'm using the formula in a cell to get the subtotal of a column, however, I would like to show the results directly on a userform label without having to use a formula to generate the results then caption the result to the label from the cell. Is this possible? I don't want have any formulas in the sheet.

=SUBTOTAL(9,P15:P107)

 

[RSpin]

If I understand what you want correctly, then this might do it.
Inside of your UserForm_Initialize sub, you can put the line:

Me.Label1 = Application.Sum(Range("P15", "P107"))

Just rename the Label1 to whatever the name of your label is.

Hope this helps.

 

[Fluff]

For a subtotal use

Me.Label1 = Application.Subtotal(9, Range("P15:P107"))

 

[Av8tordude]

Thank you everyone for the help Greatly Appreciated!

 

[Fluff]

You're welcome & thanks for the feedback