updating a text box

i'm trying to update a "text box" with a value from a cell on another
worksheet. i've figured out how to do this simiply by entering the
appropriate cell in the 'LinkedCell' area in the properties box. however,
the linked value comes in as text, when it is actually a number, formatted
with a comma and a dollar sign. Is there some obvious thing I am missing,
like instead of a text box, use a "number box"?

linked cell enters the value exactly as it's displayed. hint, choose another
cell on the same worksheet that has the value that changes then enter this
formula
=(here enter the address for the dollar value cell)
make sure the format for that cell is general NOT currency
then use that cell as the linked cell instead of the currency one

"DirInfo" wrote:

> i'm trying to update a "text box" with a value from a cell on another
> worksheet. i've figured out how to do this simiply by entering the
> appropriate cell in the 'LinkedCell' area in the properties box. however,
> the linked value comes in as text, when it is actually a number, formatted
> with a comma and a dollar sign. Is there some obvious thing I am missing,
> like instead of a text box, use a "number box"?

i'm sorry did i nmisunderstand your question, did you want the text box to
display dollar signs?

"DirInfo" wrote:

> i'm trying to update a "text box" with a value from a cell on another
> worksheet. i've figured out how to do this simiply by entering the
> appropriate cell in the 'LinkedCell' area in the properties box. however,
> the linked value comes in as text, when it is actually a number, formatted
> with a comma and a dollar sign. Is there some obvious thing I am missing,
> like instead of a text box, use a "number box"?

There is unfortunately no Number Box. The problem of the textbox is that
1. it display the value of a number (diplaying 3.145 if number formated as
$3.15)
2. if someone types some value in the box, the value is sent to the linked
cell AND this cell is formatted as Text ie 3.1456 become the String "3.145"
(of, course it also looses all number formatting)

The only way i am aware of to use a textbox in such a situation is to manage
the _Change event of the Textbox and manage the link to the cell yourself
without LinkedCell.

Maybe someone will have a better solution.
Regards,
Sebastien

"DirInfo" wrote:

> i'm trying to update a "text box" with a value from a cell on another
> worksheet. i've figured out how to do this simiply by entering the
> appropriate cell in the 'LinkedCell' area in the properties box. however,
> the linked value comes in as text, when it is actually a number, formatted
> with a comma and a dollar sign. Is there some obvious thing I am missing,
> like instead of a text box, use a "number box"?