Cell data in Text Box
 

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

Cell data in Text Box
 

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




"Luke" wrote:

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

Cell data in Text Box
 

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

"CLR" wrote:

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




"Luke" wrote:

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

Cell data in Text Box
 

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



"Luke" wrote:

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

"CLR" wrote:

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




"Luke" wrote:

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