-
Solved: Retrieve a value from the last cell and post it in a textbox
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules