Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |