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

SUBSCRIBE: [ Ссылка ]

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:
- 'Dynamic filtered range on a map in excel' [ Ссылка ]
- 'How to make a dynamic heat map in excel' [ Ссылка ]
- 'Compare lists to find missing values in excel' [ Ссылка ]

свернуть