Rlb53
08-24-2011, 01:58 PM
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.
Private Sub TextBox1_Change()
UserForm13.TextBox1.Text = Range("M200_Inv_Balance", Cells(Rows.Count, 0).End(xlUp)).Value
End Sub
Thank you for your assistance.
I'd like for the information to be retrieved without changing the viewed screen. Hence creation of the userform.
This certainly does not work.
Private Sub TextBox1_Change()
UserForm13.TextBox1.Text = Range("M200_Inv_Balance", Cells(Rows.Count, 0).End(xlUp)).Value
End Sub
Thank you for your assistance.