View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
StargateFan[_3_] StargateFan[_3_] is offline
external usenet poster
 
Posts: 171
Default VB msg box - can it have a title?

On Wed, 02 Feb 2005 12:47:40 +0000, Andy Pope
wrote:

Hi,

The syntax as detailed in help.

MsgBox(prompt[, buttons] [, title] [, helpfile, context])


Hi, my message box isn't the usu. one. Yes, I saw this in the help
file. I just needed to know how to make a help or info message box.
Since I'm not a programmer, it can be so difficult to modify things
from the help file in order to make them work.

The solution is very simple, as seems to usu. be the case. My message
box macro looks now like this in my message box macro example file:

MsgBox "This macro pulls up a message box for the user. Use the
coding in this macro in future when you need this type of thing.",
vbOKOnly, "Message Box macro example"

I have the above macro associated to a button in this example template
so that I can call up this coding whenever I need it in the future.

Thanks.

Cheers
Andy

StargateFan wrote:
In a message box that a user pulls up with a macro, can that box have
a title? Currently there is a generic title in the title bar of the
box.

Thanks.