Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can a input prompt be added to excel spreadsheet for a value?
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Equation Blank cells until input is added | Excel Discussion (Misc queries) | |||
Prompt user for input and utilize that input | Excel Worksheet Functions | |||
How do I get rid of prompt when saving Excel spreadsheet ? | Excel Discussion (Misc queries) | |||
How do I view an Excel spreadsheet component I added in FrontPage? | Excel Discussion (Misc queries) | |||
How to save an excel spreadsheet as a text file without added quot | Excel Discussion (Misc queries) |