Text box dilema

[euge228]

can you insert 2 different text boxes within a workbook/worksheet and instruct the 2nd one to follow whatever is typed into the first one?? I know how to copy text inputs form one cell to another with the “=” symbol...but I need to do this same function text boxes??<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
HELP!!<o></o>
Euge

 

[shg]

Can't readily imagine why you'd want to do this, but assign them both to the same linked cell.

 

[euge228]

how do you assign the text box to the cell..the float anywhere? ANd when I try to relabel teh text box number to match they will not accept

 

[euge228]

I am even trying to instruct the "TextBox" to copy another TextBox, but the formula wont accept. example:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
"TextBox278 = TextBox4" getting a formulaic error message. Don't care about the formula just want to get the later Textboxes to follow the earlier ones Text!!<o></o>

 

[Mike Blackman]

Hi,

It wouldn't be a formula, you'd need to nest it in a TextBox_Exit event or similar and the line of code would be:

TextBox1.Value = TextBox2.Value

 

[euge228]

does this go on teh fx line at teh location of teh 2nd text box? example:

i havea sheet 1 TextBox87..i need sheet2 TextBox342 to replicate teh text of box 87..therfore,

should it read: =sheet1!TextBox87.value=sheet2!TextBox342.value

 

[euge228]

I also tried this at the fx line of the second text box and it gives me a says "reference is not valid" messgae

(TextBox 342.value)=(sheet1!TextBox 87.value)

however this formaula is exactly what I need to do.

 

[euge228]

I guess i dont know how to "nest" anything into the text box..can you explain?

 

[Mike Blackman]

Hi,

You can only do this with VBA not worksheet level formula.

 

[euge228]

I guess I'm in way over my head. What is a VBA? And can I write one in excel?