Sub or function not defined

[sandeep.nitie]

Hello all,

I am new to VBA programming, I was trying to run a simple program with msgbox function in it but it is giving a compile error: "Sub or Function not defined".
If I comment lines containing msg or msgbox function program runs without error. Please help me to solve this problem.

Thanks in Advance
Sandeep

[YasserKhalil]

Hi Sandeep
Welcome to the forum

Please post your code here to let others help you

[sandeep.nitie]

Public Sub convertformula()
'
' convertformula Macro
' for paste special
'
' Keyboard Shortcut: Ctrl+Shift+C
'
Answer -MsgBox("convert formula to values?", vbYesNo)
If Answer <> vbNo Then Exit Sub

Selection.Copy
Range("H5").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub

[skywriter]

It should probably be Answer = Msgbox, you have Answer -Msgbox.

[sandeep.nitie]

Thanks it worked

[skywriter]

Thanks for the rep. points.

If your original request is fulfilled please click the Thread Tools drop down box above your first post and choose solved.