Code for simple calculation

[chadski778]

I'm working my way through VBA for dummies and i'm trying some example code.

Why isn't the following code working?

Sub CubeRoot()
Num = InputBox(“Enter a positive number”)
MsgBox Num ^ (1/3) & “ is the cube root.”
End Sub

This simple procedure asks the user for a number and then displays that​

number’s cube root in a message box. In the VBE the middle two lines turn red when I enter them so there is a compile error

 

[Smitty]

It appears to be an issue with the copied text. This works fine:

<font face=Calibri><SPAN style="color:#00007F">Sub</SPAN> CubeRoot()<br>    <SPAN style="color:#00007F">Dim</SPAN> num <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Long</SPAN><br>    <br>    num = InputBox("Enter a positive number")<br>    <br>    MsgBox num ^ (1 / 3) & " is the Cube Root"<br>    <br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN><br></FONT>

HTH,

 

[Rick Rothstein]

I'm working my way through VBA for dummies and i'm trying some example code.

Why isn't the following code working?

Sub CubeRoot()
Num = InputBox(“Enter a positive number”)
MsgBox Num ^ (1/3) & “ is the cube root.”
End Sub

This simple procedure asks the user for a number and then displays that​

number’s cube root in a message box. In the VBE the middle two lines turn red when I enter them so there is a compile error

Did you type that code in or copy/paste it from somewhere? The code would work fine if those quote marks were not "stylized" quote marks... VB quote marks are straight up-and-down (like this... ").

 

[chadski778]

Thanks that works now

 

[chadski778]

Little things like that can make a big difference.

Yes I copied straight from the electronic manual. Marvellous thanks