vbOk is a constant variable and has a value of 1
you'd better modify MsgBox as following:

Private Sub txtNameofGroup_Enter()
MsgBox ("Please enter the name of the Club/Group." , vbOK, "Title")
End Sub
--
msn
---------------------------------------------
the best time to plant a tree was twenty years ago.
the second best time, is today - Chinese proverb



"SDH" wrote:

Can someone please tell me why i get the number 1 at the end of my message
when the box pops up? Also, how would i change the title of the message Box
from saying "Microsoft Excel"?

Private Sub txtNameofGroup_Enter()
MsgBox ("Please enter the name of the Club/Group." & vbOK)
End Sub