VBA centigrade to fahrenheit - farenheit to centigrade

[suedavies123]

I have 2 labels (C and F) 2 textbox (TextC and TextF) and 2 command buttons (CtoF and FtoC)
I have put in the following code but keep getting 0 as result in both no matter what text box or command button I use or what temperature I enter.
The idea is for user to input temp in Centigrade textbox and fahrenheit to show and visa versa
I know its going to be something I've done that's silly but It has to be handed in by tomorrow and I've been playing with it for three days.

Please Login or Register  to view this content.

[Fluff13]

It has to be handed in by tomorrow

Homework?
Whenever you have 2 = signs in one line of code the first part fill simply read true or false depending on whether the 2nd & 3rd are =

[suedavies123]

I know right? I'm thinking of it as using my initiative rather than cheating!...did think that but when I remove = it says compile error or syntax error

[Arkadi]

As Fluff13 said, a statement like
Answer = Centigrade = 5 / 9 * Fahrenheit - 32

Means that Answer equals the comparison between Centigrade and 5 / 9 * Fahrenheit - 32

In the CtoF code you don't need Number2... it does not matter what Fahrenheit value is in the box, since you are planning to overwrite it anyhow.

I believe what you need to calculate Answer in C to F is:

Please Login or Register  to view this content.

since Number1 is your Celsius value, and you multiply that by 5/9 then add 32 to do the conversion to F?

[Fluff13]

You could also look at using the worksheet function CONVERT

Please Login or Register  to view this content.

[suedavies123]

I have changed code but if I input 25 C which should be 77 F its coming out as 45 F and if I put in 77 F I'm getting a 0 return C?

[suedavies123]

Got It!! Thankyou so much.

[Fluff13]

Glad we could help & thanks for the feedback