Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 2nd 05, 12:40 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: May 2004
Posts: 171
Default VB msg box - can it have a title?

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.

  #2   Report Post  
Old February 2nd 05, 12:47 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,489
Default VB msg box - can it have a title?

Hi,

The syntax as detailed in help.

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

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.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #3   Report Post  
Old February 2nd 05, 12:54 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2005
Posts: 95
Default VB msg box - can it have a title?

Hi unknown,

yould you please post your name in the future? TIA.


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.


Yes it can, use: MsgBox "your message", vbOKOnly, "your
Title"

Best

Markus



Thanks.
.

  #4   Report Post  
Old February 3rd 05, 02:41 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: May 2004
Posts: 171
Default VB msg box - can it have a title?

On Wed, 2 Feb 2005 04:54:20 -0800, "Markus Scheible"
wrote:

Hi unknown,

yould you please post your name in the future? TIA.


Who is the "unknown"? Just curious.

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.


Yes it can, use: MsgBox "your message", vbOKOnly, "your
Title"


Thanks! This worked beautifully!

I used this just now:

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"

The above is the macro; I assigned this macro before to an example
button and have it as a template in an XL2K examples folder so that I
can call it up whenever I'm doing up a spreadsheet that needs to
impart info to the user.

I have an icon with a question mark that when the user clicks on it,
can read any help info contained in the message box.

Thanks much!

Best

Markus



Thanks.
.


  #5   Report Post  
Old February 3rd 05, 02:43 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: May 2004
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.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to hide a chart title, but keep the title in the chart KBratt Charts and Charting in Excel 1 July 16th 09 12:13 AM
Named range=Column title,comumn title in cellB6 use B6in equation Graham Excel Discussion (Misc queries) 2 July 21st 06 10:03 AM
Show full path title in title bar? Nor New Users to Excel 4 November 4th 05 06:00 PM
Title Dena B Excel Discussion (Misc queries) 4 August 25th 05 07:13 PM
Pasting Objects into Chart title and Axis title Sam Charts and Charting in Excel 1 June 6th 05 08:50 PM


All times are GMT +1. The time now is 04:42 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017