But it is a so bloody obvious requirement for many uses I think
it should be in VBA anyway.

What would be nice would be to add one property called Format
that is the same as the cell format in Excel and to use the Value
property to hold the Value and not just be a duplication of the
Text property. Text would be "as it is displayed" and Value would
be "as it is stored" so you could use Value in computations even when
it is displayed with other stuff like commas etc.

Chrissy.


Thomas wrote
Thats opening a can of beans,read here for possible solutions
http://makeashorterlink.com/?R20A52166

Chrissy wrote:

Does anyone have some standard code they use to turn
a text box into a numeric data entry box?

If not, how do you handle data validation for entries you
want to restrict to numeric values?

Chrissy.