P
peyman
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
it and generally how I can edit a msgbox.
thanx
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Kevin B
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.
entail some effort on your part but it would certainly provide you with all
the flexibility you could possibly want.
P
peyman
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.
P
peyman
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
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
K
Kevin B
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
Open event, changing the form name as needed:
Private Sub Workbook_Open()
UserForm1.Show
End Sub
P
peyman
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