VBA code returns "0" and no other number

**Phillip Maddi** · 07-10-2013, 06:04 PM

I am working on a VBA code that will return a value (temperature or pressure) given three inputs: refrigerant selection, temperature or pressure, and the input cell. I keep getting a return of zero no matter the inputs (the equations have been verified as correct). Below is my code and please help if possible.

Please Login or Register  to view this content.

**contracting** · 07-10-2013, 06:10 PM

This is a shot in the dark (I don't know the rest of your code), but I'm guessing you don't have variables named 'R717', 'R22'... and 'T' and 'P' If you don't, then put double quotes (") around each of those values and see what happens.

Or better yet, put Option Explicit at the top of your module, and see if you get a bunch of compile errors.

**Phillip Maddi** · 07-10-2013, 06:13 PM

Well I wanted those inputs to be typed in by the user, meaning, they choose which refrigerant and then the program performs the calculation. Is this allowed? And thank you for your help

**contracting** · 07-10-2013, 06:26 PM

Oh, it's definitely allowed for a user to enter inputs. Try replacing your function with this one.

Please Login or Register  to view this content.

As your code was written, (provided that option explicit wasn't included at the top of the module) all those Rx's, T and P were considered to be variables that initialize to "" (empty string). I have a feeling that if you entered empty strings for the first 2 inputs you'd get the result you'd expect for R717 and T.