Row count Excel

I am trying to count the number of rows in a worksheet and then feed that in a textbox for display to users

.this is giving errors..

This perhaps?

Sub countRows()
    
Dim s As Long

s = Range("C3").End(xlDown).Row - 2
MsgBox "count: " & s
UserForm1.TextBox1.Text = s

End Sub

Select allOpen in new window

I've done it this  way
------------------------------------
....

b = Range("C3", Range("C" & Rows.Count).End(xlUp)).Value
s = UBound(b, 1)

MsgBox "count: " & s
UserForm1.TextBox1.Text = s

......

However, thinking about it, you would probably need to put this code in the userform module.

I am still getting a object required error

count.xlsm

try this

ActiveSheet.TextBox1.Value = s

Thank you Steve - Awesome that works but there is one issue – can you get it to refresh as I delete or add more row. For example if user adds new rows or delete row, the text box value display refreshes automatically?? Is that achievable? So in essence no need for the test button…

I increased the points because I really need to make this module work nice :)

Perfect as it can get. Thank you Steve, that is a life saver :)

Perfect