add textbox into a formula

[zplugger]

is it possible to add a textbox into a formula?

Please Login or Register  to view this content.

this code is in cell F5, can I add this formula to textbox1 and keep the code in f5. textbox1 has to read currency, and have both read formula
Thanks

[JieJenn]

Please Login or Register  to view this content.

[zplugger]

Thanks JieJenn (incompetent I don't think so). Works great,is it possible to make the textbox read currency?

[JieJenn]

Haven't test it yet, but try

Please Login or Register  to view this content.

[zplugger]

Works like a charm

Thank You

[zplugger]

Sometime I feel so Dumb

=C6/(C5-C7)

TextBox1 = Format(Range("C6")/ (Range("C5") - (Range("C7"), ("$#,##0.00#")