View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
steve steve is offline
external usenet poster
 
Posts: 576
Default No Buttons on message box

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) *

--
sb
"Bijl167" wrote in message
...
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?



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/