Macro message

[Annie]

Is it possible to record a Macro and at the end of it have a message to
instruct the users of the file what to do. Example: I have a Macro
recorded that brings in my information in cube form from Great Plains
and I want a message to pop up to say "Please pick from the list of
dates".

Any help would be greatly appreciated.

Annie
Dublin

 

[JE McGimpsey]

Is it possible to record a Macro and at the end of it have a message to
instruct the users of the file what to do. Example: I have a Macro
recorded that brings in my information in cube form from Great Plains
and I want a message to pop up to say "Please pick from the list of
dates".

Any help would be greatly appreciated.

You can't *record* the macro doing that, but you can easily *edit* the
macro to do so. Choose File/Macro/Macros..., select the recorded macro,
and click Edit. This will open the Visual Basic Editor (VBE).

If you just want the message to display, add this line just before the
End Sub:

MsgBox "Please Pick from the list of dates."

Type Opt-F11 to return from the VBE to XL.

The users will have to click the OK button before they can continue.

If you want the user to be able to pick from the list in the macro,
you'll have to give a little more detail on how your data is laid out
and how you want the pick to work...