msgbox
 

does anybody know how I can change the size of MsgBox, the font of stuff in
it and generally how I can edit a msgbox.
thanx

msgbox
 

VB You could use a User Form and create your own message box. It would
entail some effort on your part but it would certainly provide you with all
the flexibility you could possibly want.
--
Kevin Backmann


"peyman" wrote:

does anybody know how I can change the size of MsgBox, the font of stuff in
it and generally how I can edit a msgbox.
thanx

msgbox
 

thanx Kevin.got it.

"Kevin B" wrote:

VB You could use a User Form and create your own message box. It would
entail some effort on your part but it would certainly provide you with all
the flexibility you could possibly want.
--
Kevin Backmann


"peyman" wrote:

does anybody know how I can change the size of MsgBox, the font of stuff in
it and generally how I can edit a msgbox.
thanx

msgbox
 

hi Kevin,
I've defined a label, now how can I relate it to worksheet.I need the label
pop up when I open my workbook.
thanx

"Kevin B" wrote:

VB You could use a User Form and create your own message box. It would
entail some effort on your part but it would certainly provide you with all
the flexibility you could possibly want.
--
Kevin Backmann


"peyman" wrote:

does anybody know how I can change the size of MsgBox, the font of stuff in
it and generally how I can edit a msgbox.
thanx

msgbox
 

In the Workbook module, use the something like the code below in workbook
Open event, changing the form name as needed:

Private Sub Workbook_Open()

UserForm1.Show

End Sub

--
Kevin Backmann


"peyman" wrote:

hi Kevin,
I've defined a label, now how can I relate it to worksheet.I need the label
pop up when I open my workbook.
thanx

"Kevin B" wrote:

VB You could use a User Form and create your own message box. It would
entail some effort on your part but it would certainly provide you with all
the flexibility you could possibly want.
--
Kevin Backmann


"peyman" wrote:

does anybody know how I can change the size of MsgBox, the font of stuff in
it and generally how I can edit a msgbox.
thanx

msgbox
 

MANY THANKS KEVIN,GREAT!!

"Kevin B" wrote:

In the Workbook module, use the something like the code below in workbook
Open event, changing the form name as needed:

Private Sub Workbook_Open()

UserForm1.Show

End Sub

--
Kevin Backmann


"peyman" wrote:

hi Kevin,
I've defined a label, now how can I relate it to worksheet.I need the label
pop up when I open my workbook.
thanx

"Kevin B" wrote:

VB You could use a User Form and create your own message box. It would
entail some effort on your part but it would certainly provide you with all
the flexibility you could possibly want.
--
Kevin Backmann


"peyman" wrote:

does anybody know how I can change the size of MsgBox, the font of stuff in
it and generally how I can edit a msgbox.
thanx