Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
start a macro or procedure based on user putting an x in a cell
How would I start a macro /
procedure to send the user to different parts of a spreadsheet, after a user checks a yes or no in a cell after a question? Here is the situation: The user is completing a very long spreadsheet. The user must answer yes or no to several questions. Depending on the choice of the user, they will need to complete different parts of the spreadsheet. For example: Question 46: Do you have a flat roof? Two cells are set aside for each choice: Yes or No. If the answer is yes then they will need to go to and answer question 55. If they answer no, they must answer Question 47 is €œDo you have an attic with a crawl space?€ Again Yes or No. If they answer Yes or No the user must answer different questions etc. The problem is, that I have users at remote sites filling the data in and they just answer all the questions, regardless of the instructions, and that results in incorrect calculations! It takes too much time to go back and fix their data, if I can! Any help would be appreciated greatly! Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is the macro to change background based on numeric cell value | Excel Worksheet Functions | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Macro to start when cell selected | Excel Discussion (Misc queries) | |||
Row Expansion | Excel Worksheet Functions | |||
Inserting Blank Rows Macro? | Excel Worksheet Functions |