View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default 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