functions with Dim as Double

[DKY]

I have a function in which I pull in cost and dnet and want to do multiplication with it. For some reason this doesn't work when I change Cost as string and DNET as string to Cost as double and DNET as double.

Please Login or Register  to view this content.

[MickG]

Hi, I think its because you have "Cost" and "DNET" being <> than an "Empty String" when the variables are doubles, It should be a Numerical ref.
Your Code modified below works.

Please Login or Register  to view this content.

Regards Mick

[DKY]

That's it! Thanks!

Hmm, I'm using double because I want the format to be 0.00 but it's not coming through like that. It is showing more than 2 after the decimal place. Is there another one I can use?

Also, is there a way to display the date in the following format?
08-28-08
in a cell I would use the following

Please Login or Register  to view this content.

but text doesn't seem to work in visual basic.

[Richard Schollar]

You can use Format to format your output:

Please Login or Register  to view this content.

It's worth noting that Double refers to the datatype and not how many decimal places a value of this type will hold.

Richard

[DKY]

Thank you
and with your direction of Format I was able to use the following for my date

Please Login or Register  to view this content.

[Richard Schollar]

That could be truncated to:

Please Login or Register  to view this content.