| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a cell reference in a text box
Can anyone tell me if there is a way to display the contents of a cell in a
text box? I need to display additional information on a graph and I was hoping to use something like a text box to do this. Thanks, Raul |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using a cell reference in a text box
Hi
- select the textbox - hit F2 - enter the equation sign and your cell referece -- Regards Frank Kabel Frankfurt, Germany "Raul" schrieb im Newsbeitrag ... Can anyone tell me if there is a way to display the contents of a cell in a text box? I need to display additional information on a graph and I was hoping to use something like a text box to do this. Thanks, Raul |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using a cell reference in a text box
Raul,
The control toolbox textbox has a LinkedCell property which can reference a cel. As the cell changes, so does the textbox. -- HTH RP "Raul" wrote in message ... Can anyone tell me if there is a way to display the contents of a cell in a text box? I need to display additional information on a graph and I was hoping to use something like a text box to do this. Thanks, Raul |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using a cell reference in a text box
Thanks,
Raul "Bob Phillips" wrote: Raul, The control toolbox textbox has a LinkedCell property which can reference a cel. As the cell changes, so does the textbox. -- HTH RP "Raul" wrote in message ... Can anyone tell me if there is a way to display the contents of a cell in a text box? I need to display additional information on a graph and I was hoping to use something like a text box to do this. Thanks, Raul |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using a cell reference in a text box
Thanks a bunch!
Raul "Frank Kabel" wrote: Hi - select the textbox - hit F2 - enter the equation sign and your cell referece -- Regards Frank Kabel Frankfurt, Germany "Raul" schrieb im Newsbeitrag ... Can anyone tell me if there is a way to display the contents of a cell in a text box? I need to display additional information on a graph and I was hoping to use something like a text box to do this. Thanks, Raul |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using a cell reference in a text box
Is there a way to display mulitiple cells in a text box?
"Raul" wrote: Thanks, Raul "Bob Phillips" wrote: Raul, The control toolbox textbox has a LinkedCell property which can reference a cel. As the cell changes, so does the textbox. -- HTH RP "Raul" wrote in message ... Can anyone tell me if there is a way to display the contents of a cell in a text box? I need to display additional information on a graph and I was hoping to use something like a text box to do this. Thanks, Raul |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using a cell reference in a text box
You can concatenate cells to create a multiple cell entry.
In VBA for example textbox1.value = Range("A1") & " : " & Range("A2") Alternatively use a listbox with multiple columns. -- Cheers Nigel "Jeanine" wrote in message ... Is there a way to display mulitiple cells in a text box? "Raul" wrote: Thanks, Raul "Bob Phillips" wrote: Raul, The control toolbox textbox has a LinkedCell property which can reference a cel. As the cell changes, so does the textbox. -- HTH RP "Raul" wrote in message ... Can anyone tell me if there is a way to display the contents of a cell in a text box? I need to display additional information on a graph and I was hoping to use something like a text box to do this. Thanks, Raul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell reference within text? | Excel Discussion (Misc queries) | |||
| find cell with matching text, then reference cell in same row | Excel Worksheet Functions | |||
| Making cell reference absolute makes cell format text | Excel Worksheet Functions | |||
| Cell only shows link in text, not contents of reference cell | New Users to Excel | |||
| How can I reference data or text within a text box to a cell in Ex | Excel Discussion (Misc queries) | |||
Linear Mode
