Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro question | Excel Worksheet Functions | |||
Cell size? Or size limit for Text data type? | Excel Discussion (Misc queries) | |||
Cell data not visible (I have wrapped text & resized) | Excel Worksheet Functions | |||
Using a Text / Data output as a cell reference | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |