Passing in values

**froggy19** · 07-19-2007, 03:38 AM

Hi,

i have attached parts of my code which is not doing properly as i am not sure which part of it is wrong.

Please Login or Register  to view this content.

It does not seems to be able to calculate ff

http://www.mrexcel.com/board2/viewto...364790#1364790

**froggy19** · 07-19-2007, 04:41 AM

Hi,

i realise the problem only happens when the values in my worksheet "Data" is too small such that when the multiplication is done, the value is rounded to nearest integer so when my value is 0.01 etc, when multiplication is done, the answer i get will be 0. But when my value is 1, i get the exact answer. Is it possible for me to set in Excel vba to accept digits with decimal places and not have them round to nearest integer?

Thank you.

**mudraker** · 07-19-2007, 08:33 AM

Step 1 is to declare your variables correctly

In your code

Please Login or Register  to view this content.

Only fo is declared as long type all others are variable types.
Long type can not hold decimal numbers. Use Double type

To declare variables correctly you must have variable name followed by As Type

example

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Passing in values

LinkBack

Thread Tools

Rate This Thread

Display

Passing in values

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions