Mathematical Function not working

[FranktheBank]

Hello again,

I'm not sure exactly if this is a mathematical problem or a labeling problem:

Here's the Code:

Please Login or Register  to view this content.

What it's suppose to do is take the value entered from the UserForm ('HourlyRate') multiply by 37.5 (hours in a week) and multiply that by Utilization (If the employee is full-time it would equal 1 or 100%)

When I run the macro I get "Run-time error '13': Type Mismatch"

Scrolling over the line I get:
NewSalary=0 "HourlyRate="13.68" (the dollar amount I chose on the Userform) and Utilization="100.00%"

I get no feedback when I scroll over the "*37.5*"

Any ideas?

Thanks

[xladept]

Maybe:

Please Login or Register  to view this content.

[FranktheBank]

Nope.No change BTW what does 'Single' define it as??

[FranktheBank]

I'm not understanding why excel is not recognizing the formula??

[xladept]

Single makes it so you can have decimals, it's less than Double but usually adequate.


try:

Please Login or Register  to view this content.

[MrShorty]

If your use of quotation marks is accurate, it suggests that the values stored in HourlyRate and utilization are text strings (that look to us like numbers, but VBA may not be able to see them as numbers). I would suggest that you use VBA's type conversion functions (https://msdn.microsoft.com/en-us/lib.../gg264670.aspx ) to force values entered into text boxes in a userform (which are treated as text, if my limited experience is correct) into an appropriate numeric data type. I tend to push almost all my numbers into double so I use the CDbl() function most.

[FranktheBank]

Thanks the CDbl() got it!

Please Login or Register  to view this content.

Now I need to put days in there!?!?!