I'd like to retrieve a value from the last cell within a named range (which is a column) of a named worksheet and post the value within a textbox of a userform.

I'd like for the information to be retrieved without changing the viewed screen. Hence creation of the userform.

This certainly does not work.

[vba]
Private Sub TextBox1_Change()
UserForm13.TextBox1.Text = Range("M200_Inv_Balance", Cells(Rows.Count, 0).End(xlUp)).Value
[/vba]End Sub

Thank you for your assistance.