Thread: Close msgbox ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Close msgbox ?

It is not possible to have a MsgBox without buttons. Even a style of
vbInformation gives an OK button.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Buddy Lee" wrote in message
...
Is it possible to close a msgbox that contains no buttons ?
e.g.
msg = "Please wait ..."
style = vbInformation
title = "something ... :)"
msgbox(msg, style, title)
.
.
. 'some code

than I need to close the msgbox automatically

I know that another way is to insert a UserForm and show it and hide.

--

icq 25372592