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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select drop down menu option using libre-calc macro 0
Access DLOOKUP with IF Function in MS ACCESS DB 0
A simple inputbox & responding msgbox coding 4
msgbox in VBA 6
Excel Message box with days of month & date. 1
MDI Parent-Child Multiple Events Firing 0
Bold Text In Msgbox 2
Meaning of On Error Goto 0 5

Back
Top