WONGMEISTER
Board Regular
- Joined
- Jun 15, 2002
- Messages
- 107
I'm not sure if this can be done in Excel or not. I'm more Access-grounded and have used command buttons to do all sorts of things in an Access form, but here it goes...
In an Excel spreadsheet, I have certain cells in which the user will input values. They are A1, B4, B5 and C4. After the user inputs these values, other cells (that have formulas) display values. This is used for "What-If" scenarios.
If the user wants to input different numbers for the "What-If" scenarios, I want the user to be able to click a command button, and this would reset the cells (A1, B4, B5 and C4) to their original blank values.
How can I do this with the command buttons? I tried creating a command button, but I can't figure out the proper syntax for the code, assuming that this is the correct method.
Thanks in advance.
In an Excel spreadsheet, I have certain cells in which the user will input values. They are A1, B4, B5 and C4. After the user inputs these values, other cells (that have formulas) display values. This is used for "What-If" scenarios.
If the user wants to input different numbers for the "What-If" scenarios, I want the user to be able to click a command button, and this would reset the cells (A1, B4, B5 and C4) to their original blank values.
How can I do this with the command buttons? I tried creating a command button, but I can't figure out the proper syntax for the code, assuming that this is the correct method.
Thanks in advance.