TextBox????

  • Thread starter Thread starter BobT
  • Start date Start date
B

BobT

Sending data to "accounting"formatted column in a
spreadsheet froma form,appears to enter as text(no
formatting whatsoever). This is a new textbox added to an
old form.
I've reloaded Excel 2000.
Thanks for any help.
 
Any chance you're not sending real numbers to that cell?

If your data is in C12, if you put =isnumber(c12) in another cell, what do you
get?

if it's not a number, then the numberformat won't do anything.

If this is true, maybe you can clean up the value in the textbox.

worksheets("sheet1").range("C12").value = cdbl(textbox1.value)

(with some more validation!)
 
Back
Top