No Buttons on message box

[Bijl167]

Ok thnx to the help from here I've created a messsage box that
automatically disappears.

What I try to do now is to create a message box without the OK button
(or any other button). So just a message in a window.
I however do not want to design a Userform, since I'll need this type
of box many times in my program with different messages.

Does any one know of a solution?

 

[Tom Ogilvy]

There isn't an option to not show a button for that type of msgbox:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/wsmthpopup.asp

 

[pfsardella]

If your goal is to display a message for a certain period of time, you
could probably adapt the 'DisplayTextBox' routine in this thread.

http://www.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&safe=off&th=8e3b2cb283dc776c&rnum=1

HTH
Paul

 

[Bijl167]

I know that it is not a standard option. THere must be a way to not show
the buttons. Maybe by defining a message in a different way which I
don't know of. THe only requirements that I've gor is that a Userform
is impossible due to efficiency.

any one else?

 

[Tom Ogilvy]

Even the Windows API message box doesn't have an option for showing no
buttons, so I doubt you will be able to do this since that is the basis for
the messagebox you are using.

 

[steve]

A funky way might be to have your code insert a sheet.
Turn off grid lines.
Put in text (where and how you want it)
Than delete the sheet.

Or use a xlVeryHidden sheet and just show it and change the text
Than rehide it.

Using the following will help eliminate flicker
Application.ScreenUpdating = False
* some code *
Application.ScreenUpdating = True
* more code (if you want) *