Excel VBA code question regarding Message Box

[PGD15]

Hi,

I've got a question regarding VBA coding and the message box functions.

currently I've got a string of information (where the goal is not to have a message, all messages displayed are error messages). However if my string is empty/blank (so no errors) is there a way to say "no error found" in the same msb box

so in simple effectively if the message box string is empty/blank up to this point add to the string "No errors found"?

currently i have a second message box pop up saying that.

 

[GJSBED]

[/COLOR]Sub Macro17()
'
' Macro17 Macro
'




If ActiveCell.Value <> "Good" Then MsgBox "bad news"


If ActiveCell.Value = "Good" Then Macro19


End Sub




Sub Macro19()
MsgBox "good news"
End Sub

This might help, if the cell says Good (no errors) it does one thing if it says nasty stuff (errors everywhere!) it jumps to another macro to show a different box

 

[PGD15]

Hi GJSBED,

Thanks for the reply, unfortunately this doesn't help me. Its not essential i get this working but it just looks nicer for my end user. Thanks anyway