I have a macro that does some formatting.

I need to prompt the user at the beginning of the macro for the name of a data range.

I would like to pass the answer they provide as a parameter to a function in my macro.

Is there a way to create a message box at the beginning of the macro to solicit this input from the user?

TIA!!!

Heather.