Can a input prompt be added to excel spreadsheet for a value?

[Guest]

I setting up a Quiz Scoresheet that will run a macro to generate the
appropriate competition grid layout. Scenario: Competition Grid Menu is
selected and I would like the a pop up screen to ask "Number of
Competitions"; based on the input, the appropriate grid macro is selected and
the grid is drawn in the Competition Grid Worksheet tab.

 

[Guest]

Thanks much for the quick response... testing it out.. I believe it should
work ... I appreciate your help....

I did some more searching... (after walking away from the computer screen
and getting some fresh air) and found additional resource fm the Microsoft
online tutorial area..

http://office.microsoft.com/training/training.aspx?AssetID=RC010969991033