limiting decimal places in a msg Box

[obracey756]

Hi all

First of all thanks for your help!

I'm trying to do something which I thought would be easy but it seems to beyond my (all be it limited) intelligence.

Im trying to create a button which when you click it and enter a number it takes that number and divides it by 230 and shows you the answer in a message box.
That bit's fine, however i'm trying to limit the answer to a couple of decibel places. This is my code;

Sub AmpCalculater()
Num = InputBox("Enter Watt")
If Len(Num) = 0 Then Exit Sub
MsgBox = Format(Num / 230, "0.00") & " Amps."
End Sub


What am I doing wrong?

Thanks for the help again

Ollie

 

[RoryA]

Remove the = from the MsgBox line.

 

[obracey756]

So Simple!

Worked like a treat, Thanks RoryA

Ollie

 

[RoryA]

Glad to help. Welcome to the forum by the way.