Cell data in Text Box

L

Luke

Hi,
Is it possible to embed cell data in a text box, so when the value in the
cell changes the value in the text box will also change.
Many thanks
Luke
 
C

CLR

Highlight the Text-box, then go to the formula bar and type =A1......then
whatever value is in cell A1 will also appear in the Text-box...

hth
Vaya con Dios,
Chuck, CABGx3
 
L

Luke

Hi Vaya,
Thank for that. Is it possible to imbed a command in the text with in the
text box which will show cell value. ie (in the text box) " today we have
sold (=A1) cars "
so the value of A1 is displayed?
Many thanks
Luke
 
C

CLR

Put this formula in another helper cell somewhere, say X1 and refer the
Text-box to it instead of directly to A1..........

="Today we have sold "&A1&" cars."

hth
Vaya con Dios,
Chuck, CABGx3
 
Top