Macro pause for input

[Bill]

I would like a macro to insert a footer with some data
already in a worksheet. I can do that, but I want it to
pause and offer choices, e.g. a dropdown box or something,
so that the choice is between two or more cells/named
ranges in the worksheet, or choices such as left or right
footer and Active.Workbook.FullName or "Date" such as date
is "Date: &D"

Suggestions greatly appreciated.

 

[Jase]

Have you tried using Forms in your macro? Or even using
the msgbox command will probably suffice.

Look msgbox up in the help from your macro