Skip to content

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

Playback starts YouTube’s embedded player (privacy-enhanced mode).

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

53,031 views October 26, 2019 8:47

Watch on YouTube

ChannelKarina Adcock

Description from the creator

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: goo.gl/c46YPs

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' youtu.be/mCi5NFZ_j6U
- 'How to make a dynamic heat map in excel' youtu.be/62G8edt2go8
- 'Compare lists to find missing values in excel' youtu.be/pW6ZWH7YwZQ

About this tutorial

Karina Adcock published this 8:47 video tutorial on October 26, 2019. It has been watched 53,031 times on YouTube.

Channel: Karina Adcock
Category: Science & Technology
Duration: 8:47
Published: October 26, 2019
Views: 53,031
Likes: 196

Tags

Share

Further reading

vba - How do I link an Excel Check Box (ActiveX Control) to a cell ... stackoverflow.com
Linking an Excel Check Box (Form Control) to a cell is easy: 1) Add a Check Box. 2) Select the Check Box (I normally right-click it). 3) In the Formula Bar, type "=".
Link a Cell to Active X Text box - Excel Help Forum excelforum.com
Hi Everyone, How do you link a cell to active x textbox wherein the cell is constantly changing because it is base on an activex combo box?. Whenever the combox is change the text box should also be updated with the val…
How to link textbox to a specific cell in Excel? extendoffice.com
Link a textbox to specific cell in Excel. In Microsoft Excel we can link a textbox to a specific cell to show the linked cell content in the text box. What's more, if the value of the linked cell is changed, the textbox…

This tutorial in other languages

Web Analytics