Karyn,

An easy way to create a simple prompt is with the InputBox() function. Put
this into your button macro:

Cells(1,1) = InputBox("Type in something", "My Title")

See help for InputBox() for more options available for the function.

If you want fancier input boxes, you would create User Forms in the Visual
Basic Editor, which gets a bit more complex.

Lee

"Karyn" wrote in message
...
I had created a program a few years ago in Excel, but can't remember how
to
do it now. I had a button assigned to a macro, and when the user clicked
the
button, a series of pop up boxes prompted the user for information. That
information was then used in the spreadsheet. Now I can't even remember
how
to make the pop up boxes. Can anyone help please?