Msg boxes in VBA
Thanks for your quick replies!
I know I'm being a pain now but I copied and pasted the code into my macro
and it's still giving me the same error. The compiler wants something before
MsgBox. I'm completely in the dark as to what it wants.
Sabrina
"Bob Phillips" wrote:
You removed the comma after the message contents
Sub show_Question01()
'
' show_Question1 Macro
' This macro shows the user the text to Question 1 in the chart.
'
With Worksheets("Data w Charts")
MsgBox Prompt:=.Range("B1"), _
Title:="Question Text"
End With
End Sub
|