Microsoft KB Archive/38752

Inserting Numeric Data or a Date into an Input or Alert Box PSS ID Number: Q38752 Article last modified on 02-26-1993 PSS database name: W_eXceL

2.00 2.01 2.10 3.00 | 2.20 2.21 3.00

WINDOWS | OS/2

Summary:

The following two command macros in Excel will put an Alert box and an Input box on the screen and will display text along with the current date:

=ALERT(&quot; text string “&TEXT(NOW,”mm-dd-yy&quot;),2)

=INPUT(&quot; text string “&TEXT(NOW,”mm-dd-yy&quot;),2)

More Information:

The ampersand (&) tells Excel to concatenate the text. “TEXT” formats data to whatever text string you want. “NOW” returns the serial number for the date, concatenating the formatted date onto the text string.

Additional reference words: 2.00 2.0 2.01 2.1 2.10 2.2 2.21 2.20 3.00 3.0

Copyright Microsoft Corporation 1993.