About Us

SDH

excellent, thanks very much timebird

"timebird" wrote:

drop "(" and ")"
--
msn
---------------------------------------------
the best time to plant a tree was twenty years ago.
the second best time, is today - Chinese proverb

"SDH" wrote:

thanks timebird, but now i get a compile error: Syntax Error with

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

"timebird" wrote:

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MessageBox with tick box	Sophie	Excel Discussion (Misc queries)	3	February 5th 09 02:32 PM
messagebox help	jimE	Excel Programming	3	November 3rd 06 07:49 PM
Anything wrong with Messagebox API?	RB Smissaert	Excel Programming	2	January 23rd 06 06:55 PM
messagebox problem	Sam	Excel Programming	1	February 6th 05 05:32 PM
Working around a messagebox	JustinR	Excel Programming	1	May 26th 04 01:53 AM

Menu

About Us