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

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

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

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

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

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

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