Hi-
Im trying to enter the value of a cell into a textbox on a userform. This is the code that initializes when the userform is shown:
Private Sub UserForm_Initialize()
Sheets(TextBox3.Text).Activate
ActiveSheet.Visible = True
[e7000].End(xlUp).Offset(0, 0).Select
TextBox2.Text = Range.Offset(0, 0).Value
End Sub
The value of the cell that is selected using the line:[e7000].End(xlUp).Offset(0, 0).Select . This finds the cell that im looking for, but I cant seem to figure out how to list it in textbox2. As you can see Ive tried a code(tried many other ways also) to show the value, but its not working. Perhaps I should use the offset methode, but im not sure how to apply it to this code. Please help?
Im trying to enter the value of a cell into a textbox on a userform. This is the code that initializes when the userform is shown:
Private Sub UserForm_Initialize()
Sheets(TextBox3.Text).Activate
ActiveSheet.Visible = True
[e7000].End(xlUp).Offset(0, 0).Select
TextBox2.Text = Range.Offset(0, 0).Value
End Sub
The value of the cell that is selected using the line:[e7000].End(xlUp).Offset(0, 0).Select . This finds the cell that im looking for, but I cant seem to figure out how to list it in textbox2. As you can see Ive tried a code(tried many other ways also) to show the value, but its not working. Perhaps I should use the offset methode, but im not sure how to apply it to this code. Please help?