View column A value based on the active cell

[JohnBi]

Hello to everyone,
how may I see in a TextBox the value of a cell in colum A based on the active cell?
For example:
- Active cell = H25 --> Textbox = A25 value
- Active cell = H20 --> Textbox = A20 value
- Active cell = C125 --> Textbox = A125 value
- Active cell = F87 --> Textbox = A87 value

Thank you for your help.
Regards
John

 

[JohnBi]

OK, I thought you just had a textbox on worksheet directly.
If it is textbox on a UserForm, then you just should put the one line of code I originally gave you to whatever code is bringing up the UserForm.

I add your code on the UserForm_Initialize() and the first time I open the form is Ok.
Then, when I made changes in the range C11:H133 the textbox is not anymore updated. I need to close and reopen.
Regards
John

 

[Joe4]

So, you have the UserForm open the entire time, and you want the UserForm to be updated automatically and immediately while you are updating cells on the worksheet?
It seems kind of odd to have both open and being updated at the same time.
What exactly are you doing?

 

[Joe4]

OK, I seldom work with user forms, but I just did some research, and it looks to me that you just need to add a User Form reference in front of the text box name, as shown here:

Userform textbox to display realtime a worksheet cell's dynamic value

Problem seems so simple yet almost impossible for me to solve, hope you guys can help me. I basically just need a textbox on a userform to reflect the value calculated on a worksheet cell. I have tried sourcing the cell where i learned that deletes the formula in the cell, evenso those...

www.mrexcel.com

i.e.

Private Sub Worksheet_Change(ByVal Target As Range)
'   See if update happened in range C11:H133
    If Not Intersect(Target, Range("C11:H133")) Is Nothing Then
        UserForm1.TextBox5.Value = Cells(ActiveCell.Row, "A").Value
    End If
End Sub

 

[JohnBi]

Sir, thank you, and thank you again.
It is perfect!

Regards
John

 

[Joe4]

You are welcome.
Glad we were able to figure it all out!