msgbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
thanx Kevin.got it.

Kevin B said:
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.
Click to expand...
 
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
 
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
 
MANY THANKS KEVIN,GREAT!!

Kevin B said:
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
Click to expand...
 
Back
Top