My some basic programms always show syntax error when i run macros

[syedfahadjalali]

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

why this macro always gives my syntax error ?

[TMS]

This works for me. I've changed the quotes ... did you copy this code from somewhere?

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

Regards, TMS

[syedfahadjalali]

if i copy any basic code from my tutorial pdf file it always give me systax error

[syedfahadjalali]

Thanks after retyping the quotes it is working fine for me :D

[syedfahadjalali]

yes i copied this code from a pdf tutorial

[TMS]

They're using a different double quote character ... so you will need to do a global replacement of what you get from your PDF file for this double quote (").


Regards, TMS

[stanleydgromjr]

syedfahadjalali,

The following works for me:

Option Explicit
Sub CubeRootV2()
' stanleydgromjr, 03/02/2013
' http://www.excelforum.com/excel-programming-vba-macros/903853-my-some-basic-programms-always-show-syntax-error-when-i-run-macros.html
Dim Num
Num = InputBox("Enter a positive number")
MsgBox (Num ^ 1 / 3 & " is the cude root of " & Num)
End Sub