Expected: Line Number or Label or Statement or End of Statement

[scooke]

I am getting the error:

Expected: Line Number or Label or Statement or End of Statement

I am using Excel 2007 and here is the code:

Sub GuessMyName()
    Msg = "Is your Name" & Application.UserName & "?"
    Ans = MsgBox(Msg, vbYesNo)
    If Ans= vbNo Then "Oh Never Mind"
    If Ans= vbYes Then "I am pretty Smart!"
End Sub

This code came from Chapter one of book so I had hoped not to hit a roadblock so soon! Maybe I picked the wrong book! Any help would be appreciated. I have turned off requiring that variables be initiated. I normally wouldn't do that but this is a pretty simple test (at least I thought so). Thanks so much.

 

[Rick Rothstein]

I am getting the error:

Expected: Line Number or Label or Statement or End of Statement

I am using Excel 2007 and here is the code:

Sub GuessMyName()
    Msg = "Is your Name" & Application.UserName & "?"
    Ans = MsgBox(Msg, vbYesNo)
    If Ans= vbNo Then [B][COLOR=#b22222]"Oh Never Mind"[/COLOR][/B]
    If Ans= vbYes Then [B][COLOR=#b22222]"I am pretty Smart!"[/COLOR][/B]
End Sub

This code came from Chapter one of book so I had hoped not to hit a roadblock so soon! Maybe I picked the wrong book! Any help would be appreciated. I have turned off requiring that variables be initiated. I normally wouldn't do that but this is a pretty simple test (at least I thought so). Thanks so much.

The two text strings I highlighted in red cannot just stand alone like that... something has to be done with them (such as assign it to a variable or display it somewhere). My guess is you missed putting in the MsgBox function call so that the text strings would be displayed somewhere...

Sub GuessMyName()
    Msg = "Is your Name" & Application.UserName & "?"
    Ans = MsgBox(Msg, vbYesNo)
    If Ans= vbNo Then [B][COLOR=#b22222]MsgBox [/COLOR][/B][COLOR=#000000]"Oh Never Mind"[/COLOR]
    If Ans= vbYes Then [B][COLOR=#b22222]MsgBox[/COLOR][/B] [COLOR=#000000]"I am pretty Smart!"[/COLOR]
End Sub

 

[scooke]

Hi Rick,

Thanks for the reply so quickly. I just double checked my book and I have typed that our verbatim which is pretty sad. Being such a rookie, I'd hate to ask but how would you suggest I do what I am attempting to do? Thanks again...

 

[scooke]

Sorry Rick,

Now I see that you did show an example and after checking my book, it appears I am the idiot as I missed that. Thanks again for your help!