Link User Form Text Box to worksheet cell

I have a user form that allows the user to input values. Behind the scen I have a matrix that depending on what the user inputs will return certain values in a cell using the INDEX function. I would like the results to display on the User Form in a field. My question is how to I link the Text box on the user form to the calculated field on the worksheet?

this code will fill TextBox1 with the contents of the cell refered to (you will need to edit SheetName, RowNumber & ColNumber to meet your requirements

TextBox1.Value = Sheets("SheetName").Cells(RowNumber, ColNumber)

I presuume you will need to link this to an 2event" on your userform

let me know how you go

hth

It still is not working. It will not display the results. The cell I am trying to link to is H2. My worksheet is Sheet1 This is what I have for my code right now:

Private Sub TextBox3_Change()
TextBox3.Value = Worksheets("Sheet1").Cells(H, 2)
End Sub

Still doesn't work. This is what my code looks like after the recent change:

Private Sub TextBox3_Change()
TextBox3.Value = Worksheets("Sheet1").Cells(2, 8)
End Sub

I got it. You can use the Control Source to link it to the cell needed.

Originally Posted by jamphan

I got it. You can use the Control Source to link it to the cell needed.

VBA code would look like

Please Login or Register  to view this content.

This will pass the value from Cell H2 on Sheet1 to the specified Textbox.

royUK --- Are you directing your reply to my post (which follows the rules) or to the original post (jamphan). You should probably be specific when you post a reply to a reply.

Hope that helps

caper1965
-----

Hi Caper1965.

I saw your post and have tried the same as below

[I][I][I]Re: Link User Form Text Box to worksheet cell
Quote Originally Posted by jamphan View Post

I got it. You can use the Control Source to link it to the cell needed.
VBA code would look like



copy to clipboard
TextBox3.Value = WorkSheets("Sheet1").Range("$H$2").Value
This will pass the value from Cell H2 on Sheet1 to the specified Textbox.

I have a drop down combobox (Customer names) that refers to cell D8 and then cell D6 uses a Vlookup to retrieve the selected customers account number and display it in cell D6. How do I get the result shown in D6 to show in a textbox in a user form?

what if i have to copy data from text box to another code?