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

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.

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

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...RC010969991033

"Jim Thomlinson" wrote:

This is a rough outline of what you want I think...

Sub SelectGrid()

Select Case InputBox("Number of competitions")
Case 1
MsgBox "One"
Case 2
MsgBox "Two"
Case 3
MsgBox "Three"
Case Else
MsgBox "Invalid input. Please Try again"
End Select
End Sub
--
HTH...

Jim Thomlinson


"antwash" wrote:

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.