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
Highlighted
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

0 Replies