Here is the basics.

1. Create the button on a worksheet -
Access View:Toolbars:Forms to display the "Forms" toolbar.
Click on the "Button" tool.
Click and drag the pointer across a small part of your worksheet.
The button should now be on your worksheet.
2. Edit the text on the button by clicking on the botton you just made then
typing something like "Start" or "GO".
3. Startup the VBA editor.
4. Add a code module to the workbook.
5. In the project explorer, double-click on the module you added. Then type
in the following

Sub MyMacro()

response=inputbox("Enter some text or number here.", "My Input Box")

End Sub

6. Then go back to your button on the worksheet and right-click on it.
Select the "Assign Macro" from the popup menu.
7. Double-click on the macro "MyMacro" that should be displayed on the
list.

Your done!

Click on the button you made on the worksheet and see what happens.


Dennis

"Lewej23" wrote in message
...
In college I had an assignment that required me to create a button in a
worksheet that, when pressed, a form would come up where the user could
input
information. I remember it had something to do with macros. Does anyone
know
how to do this?