Pop-Up (Lalit Sharma)

[Guest]

R/Sir,

How can we generate pop-up in the MS-Excel?


Thanks a lot,

Lalit Sharma

 

[Chip Pearson]

Try

MsgBox "Hello World"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting LLC
www.cpearson.com
(email on the web site)

 

[Debra Dalgleish]

You can create a message with data validation:

http://www.contextures.com/xlDataVal04.html

 

[Guest]

Hi,

Do the following:

1. On the Data menu, click Validation.
The Data Validation duilaog box appears.
2. Click the Error Alert Tab.
3. Slect the Show error after invalid data is entered check box.
4. Click the Style list, and choose Stop, Woarning or information.
5. In the Title box, Enter a description of the Alert message.
6. In the Error Message box, enter the cause for the error message.
7. Click OK, to save the properties in the Data Validation dialog box before
returning to the Excel sheet.

Note: This example if one of the ways to create message boxe. However you
could decide to describe them the way you prefer the message box to appear.

Challa Prabhu