More Message Box Questions

K

Krakmup

G'Day

Is it possible to display a message box for a finite amount of time, then
close the box without user intervention, and still allow the program macro's
to run in the background?

Is it possible to program the font size and type inside a message box?

Krakmup
 
J

Jay Freedman

G'Day

Is it possible to display a message box for a finite amount of time, then
close the box without user intervention, and still allow the program macro's
to run in the background?

Is it possible to program the font size and type inside a message box?

Krakmup
Click to expand...

The answer to both questions is "no if you use a MsgBox statement, but
yes if you use a Userform that looks like a messagebox".

For the first question, see
http://word.mvps.org/faqs/userforms/CreateASplashScreen.htm.

For the second question, you can either set the font name and size at
design time in the Properties pane for the label you insert, or you
can do something like this in code at run time:

Private Sub UserForm_Initialize()
With Label1.Font
.Name = "Comic Sans MS"
.Size = 12
.Underline = True
End With
End Sub
 
Top