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
|