This is for Fahrenheit to Celsius

[Rileys98]

Trying to use an excel formula in a VBA code. I'm sure I have the syntax wrong. Appreciate the correct way to write it.
A message box comes up and you put a number in it. I want it converted and then variable b to state what it is.
I'm sure I'm falling down with syntax after be =
You can see I'm new at this so appreciate any help.

Dim a As Variant
Dim b As Variant

a = Application.InputBox(prompt:="Type in a number", Title:="Type a Fahrenheit temperature", Default:="Type your temperature here", Type:=1)

b=Application.WorksheetFunction.(Convert(a,"F","C")

MsgBox "Celsius equivalent degrees:" & vbCrLf & Round(b, 1)

 

[Fluff]

Hi & welcome to MrExcel.
You just need to remove the ( from before Convert

 

[Rileys98]

Hi & welcome to MrExcel.
You just need to remove the ( from before Convert

Wow thank you! I ALMOST had it. I was trying for an hour on this one!

 

[Fluff]

Glad to help & thanks for the feedback.

 

[jolivanes]

Fluff got you sorted but, if you want to, you could make it slightly more compact.

Sub Maybe()
Dim tempF As Long
tempF = Application.InputBox("Temperature in Fahrenheit:", "Convert to Celsius.", "Enter Temperature Here!", 1)
MsgBox Format(WorksheetFunction.Convert(tempF, "F", "C"), "#.00")
End Sub