How to link an ActiveX control textbox to a cell in excel

Use the Developer tab and some simple VBA to connect an active X control text box to a cell in the workbook so you can change the value in the text box and the value in the cell will change to match it.
Private Sub TextBox1_Change()

ActiveWorkbook.Worksheets("Sheet2").Cells(1, 8) = ActiveSheet.TextBox1.Value

End Sub

---------------------------------------------------------------------------------
#exceltipsandtricks #excelvba #exceltutorial

VIDEO INFO: These data are related to my PhD research.

Microsoft Office 365, 2016, Office Insider, Version 1812
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:

[johnskorupa]

Thank you Karina! Very clear instructions. I've viewed many other videos on how to link Excel cells to a VBA textbox and you were the first to help me succeed! I am subscribing to videos.

[AnasBaso]

Thanks you. Can you olease also help to create example to change the value of TextBox if a value of a specific cell is change?

[tapan]

if both sheet have text box control and one sheet text box control change then another sheet text box control value change automatically please let me know

[NonCrazyNorGamer]

1:25 Couldn't we just select the wanted cell in "Refrence Cell"? I just tried that and it worked just fine!

[terrylamplough]

brilliant tutorial... however iam trying to update a text box instead of a cell. i've tried replacing the Cell range in the vba with the textbox but doesn't work. any thoughts would be gratefully received. regards Terry

[BLACK-hlic]

Please make a video of
Command & Option Button.
Check Box

[jan-lucako]

How would i put text into a textbox itself first, without assigning it to a cell basically?

[jorellcarbonell]

How can i format the textbox into percentage?

[kamleshsharma]

I have two textbox, how to move one textbox to other textbox without clicking by mouse

[flyeract]

I want the format of the value in text box change into percentage, just as the same as the reference I put (the cell reference also in % format)
how do I make this?

[devaproduct]

What if I want to see the text box only when I select the cell otherwise it remains hidden, how to do it? Could you help me in that.

[ccb]

you do know you can just go to the "Linked Cell" within properties with out having to create a VBA script.

[GsTJair]

Hi, how i can show the value of a cell in a activex control textbox,
nice video ;)

[navinreddy]

HOW TO LINk an activex control textbox to a multiple cell