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