Problem with If- then statements and with .Value command.

[kjy1989]

I have a textbox in a form which i named: Textbox_DownpaymentAmount which amounts to 16,000

I have a variable called "Cell" which is located on a spreadsheet with an amount of 15,000.

Below "Cell" ( Cell.offset(1,0) ) is an amount of 20,000.

My code is:

Please Login or Register  to view this content.

It doesn't work...

When I use F8 to debug it line by line, I hover the mouse over the variables and I noticed that Textbox_DownpaymentAmount.value has a value of "16000" (with quotations) and values stored in spreadsheet like cell.value and cell.offset(1,0).value return a value of 15000 and 20000 respectively without the quotations ("15000" and "20000"). My guess is that excel doesnt treat textbox_downpaymentamount.value as a true number because it is defined as "16000" and not just 16000. What am i doing wrong here?

[TMS]

Maybe

Please Login or Register  to view this content.

Regards, TMS

[kjy1989]

Maybe

Please Login or Register  to view this content.

Regards, TMS

Thank you TMS it works. Question though, I want to ask when I will apply this Cdbl function? I don't want to commit the same mistake again. Do I have to do this always when I want to get the number value of a textbox in a form for computation purposes?