Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Excel Macros Questionaire
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
Hello,
I'm trying to make a questionnaire using Excel Macros (xlsm file) and I'm having trouble making the last sheet. I'll try to explain what I'm trying to do the best I can.
For this questionnaire, when the user answers all the questions (1 question per sheet, all inputs are through buttons or drop down choices), the user is sent to a "summary" sheet where all the questions are displayed again (in there own cells) with the customers answers below them (in a separate cell).
Below all these Q&A's is a choice box. The user has to push a button (the choice button) to display their best choice based on their answers to the questions. This is where I'm stuck.
When the user clicks this choice button, I want it to check one of the answers (a number value answer). If the answer value is greater than a value, then I want the choice box to display a phrase that is written in another sheet.
I bolded the "if" and "then" buttons to show that I think I have to use these kinds of commands... but I'm not sure. Any tips? I'm new to Excel Macro and I've gotten pretty far with the "Record Macro" buttons and finding what I can online... but this is stumping me. Any help is very much appreciated!
Respectfully,
Owen T.
Microsoft 365 and Office | Excel | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.