VBA Noob multiplication isn't working with decimal

[Dustin S.]

I just started using VBA and WOW at the possibilities!! I have some data I am trying to calculate and decided upon researching VBA that this would be the easiest way to do what I need to.

The code goes through no errors but D2 is .0001 and N2 is 12000 and the answer I get when I multiply the 2 through VBA is 0.000 however if I change the number in D2 to 2 then I get 24000. I tried the help menu and possibly this is because I didn't do something right with the decimal?

Please Login or Register  to view this content.

Again keep in mind this is my first attempt at writing my own VBA code, so feel free to add comments to better my formatting and such.

Thanks for any help in advance

[modytrane]

a quick comment.
why do you have the number1 and number2 declared as integers?
that's why when you make it .0001 it treats it as 0.
modytrane

[Dustin S.]

I was using examples I found online to help me write the code...

I made the assumption integer meant any number.

What should I have there?

[Dustin S.]

Changed the Integers to Doubles and IT WORKS!!!

Please Login or Register  to view this content.

Any constructive criticism on the new format?