[RESOLVED] msgbox name

i noticed today that when you pop up a msgbos using the code

msgbox "whatever"


that it always has the default name of excel. is there a bit of code i can add to change what the title of my message box is?

thanks joe

MsgBox ("hello", vbOKOnly, "Your title here")

ok so how would i use it with this

MsgBox TextBox2.Text & " is not a valid first name. Please enter a name longer than 2 characters."

because this dosnt work

MsgBox (TextBox1.Text & " is not a valid last name. Please enter a name longer than 2 characters.", vbOKOnly, Invalid last name)

dim i%
i=MsgBox (TextBox1.Text & " is not a valid last name. Please enter a name longer than 2 characters.", vbOKOnly, "Your title here")

i dont want to declare it is a variable, i just want to use it in the way i put before, but it didnt work

i think this is the procedure to declare msgbox().
if you do not want to work with the variable, then don't bother about it.
if the code i posted works then you got what you required.

MsgBox TextBox1.Text & " is not a valid last name. Please enter a name longer than 2 characters.", vbOKOnly, "Invalid last name"

yep thats great. thankyou