Macro not updated

[Formula11]

I noticed that if code is changed slightly, when run in Excel the macro does not run as per updated code.
Example is for message box.
If text is changed, it won't update in Excel a lot of the time. Sometimes it does though.
Is there a setting somewhere to account for this?

    MsgBox "– This sentence." _
    & vbNewLine & "– That sentence." _
    , 64 _
    , "About"

 

[Alex Blakenburg]

That code consistently produces the Message box below. There are no variables used so I would not expect anything else.
What is the actual issue ?

 

[Formula11]

Thanks for responding.
Maybe I didn't explain properly.

If for example "sentence" is changed to "sentence1", the message box still shows the former text, the output you have above.

 

[Alex Blakenburg]

Show me how you are changing sentence to sentence1.

 

[Formula11]

I just type it in the Visual Basic Editor.
Maybe it was a copy and paste.

The thing is that I never noticed this before, in using previous versions of Excel. Mentioning this in case it has something to do with it.

 

[Alex Blakenburg]

I would expect something more like this and even more likely would be a cell on the right hand side of the equal sign.

Sub test()

    Dim str1 As String, str2 As String
    
    str1 = "sentence no1"
    str2 = "sentence 2nd line"
    
    MsgBox "– " & str1 & "." _
    & vbNewLine & "– That " & str2 & "." _
    , 64 _
    , "About"
    
End Sub

 

[Formula11]

OK thanks but I was trying to find the reason for why it was happening.
I've coded in Visual Basic every now and again for many years, and never had the issue before.

 

[Alex Blakenburg]

I'm afraid that don't follow what the issue is. I would need to see the code you are using, the output you are getting and the output you are expecting.

 

[Formula11]

OK thanks, it's as simple as stated above.
Change code in Visual Basic Editor, in this case text in a message box, run macro, output often seems to be for the previous code.

 

[Alex Blakenburg]

I am sorry but I can't reproduce that result. The message box will faithfully reproduce the text entered on to the line.
The only way that wouldn't happen is if you had some other code with the same message box and you are not running the version of the message box you think you are running.
ie do you have the code in the Sheet module and the same code in multiple sheet modules ?