Home

VBA - How to linking text box value with another text box

%3CLINGO-SUB%20id%3D%22lingo-sub-762725%22%20slang%3D%22en-US%22%3EVBA%20-%20How%20to%20linking%20text%20box%20value%20with%20another%20text%20box%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-762725%22%20slang%3D%22en-US%22%3E%3CP%3ECould%20someone%20tell%20me%20if%20it's%20possible%20to%20link%20the%20values%20of%20different%20text%20boxes%20in%20Excel%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERoot%20cause%3A%20since%20Excel%20doesn't%20allow%20different%20column%20widths%20for%20different%20rows%20in%20one%20sheet%20(without%20merging%20cells)%2C%20I%20had%20to%20use%20some%20text%20boxes%20as%20input%20area%20in%20a%20workbook.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20purpose%20is%3A%20if%20I%20input%20certain%20content%20in%20Text%20Box%201%2C%20the%20same%20content%20will%20automatically%20appear%20in%20Text%20Box%202%20as%20well%2C%20so%20that%20I%20don't%20need%20to%20input%20twice%20the%20same%20content.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESince%20I%20know%20little%20about%20VBA%2C%20my%20trials%20have%20failed%20many%20times.%20This%20seems%20much%20more%20difficult%20than%20linking%20the%20text%20box%20value%20with%20a%20cell%2C%20but%20I%20believe%20there%20are%20people%20who%20know%20how%20to%20manage...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20537px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F123634iDCF2B02D85E94BD7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22TextBox1.PNG%22%20title%3D%22TextBox1.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20370px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F123635iEE8FA217237F66CC%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22TextBox2.PNG%22%20title%3D%22TextBox2.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-762725%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
CathySong
New Contributor

Could someone tell me if it's possible to link the values of different text boxes in Excel?

 

Root cause: since Excel doesn't allow different column widths for different rows in one sheet (without merging cells), I had to use some text boxes as input area in a workbook. 

 

The purpose is: if I input certain content in Text Box 1, the same content will automatically appear in Text Box 2 as well, so that I don't need to input twice the same content.

 

Since I know little about VBA, my trials have failed many times. This seems much more difficult than linking the text box value with a cell, but I believe there are people who know how to manage...

 

TextBox1.PNGTextBox2.PNG

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies