Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro that promt user for input
The screen goes to a cell, shows the question and user needs to respond, word
or number. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro that promt user for input
The screen goes to a cell
Do you mean that whenever a user selects a cell ? If so, then use the Worksheet_SelectionChange event The target would be whatever cell you choose. The action would be something like: Ans = Inputbox("Ask your question") If Ans = " xyz" then ' ' Do this Elseif Ans ="abc" then ' ' Do this Else Msgbox "Sorry....invalid Answer" Exit Sub End if "Fercho" wrote: The screen goes to a cell, shows the question and user needs to respond, word or number. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need macro to post data from user input | Excel Worksheet Functions | |||
Macro for user to input 10 numbers | New Users to Excel | |||
Prompt For User Mouse Input In Macro? | Excel Programming | |||
Pausing a macro for user input | Excel Programming | |||
Can a macro be suspended during user input? | Excel Programming |