MsgBox Random Title Generator

Hi Winon,

Thanks for the effort to help, but this isn't quite what I'm looking for. Since the users have their own workbooks open, I can't use Vlookup, and write any code into any specific cells on an excel sheet, therefore I must do this solely in VBA. The XLAM file does not have any actual sheets to work with, it's just full of modules that tie into a custom ribbon filled with macros. So in the case of the msgbox I'm working with, Here's an example:

msgbox1.png

So the title that says "Oops!" I want to have this randomized with a list of 25+ different sayings.

Here's a sample snip-it of the code I have that generates this:

If Range("C3").Value = "Sheet Formatted" Then
        MsgBox "This function has already been performed", vbExclamation, "Oops!"
        Exit Sub
    End If
    
    If Range("L1").Value = "New Export" Then
        Call ProceedFormat
            Else
                MsgBox "Wrong format selected. Please check your worksheet type", vbExclamation, "Oops!"
    End If