Reset button

[Thijmen10]

Hello,

I want tot make a calculator in Excel. So i need a reset button to clear everything. But i have some formulas in it aswell. How can i do it?

 

[Thijmen10]

I have the formula like this:
1 Potato = 4 Euro
Then u put in another cell 10 for 10*4
When i touch the reset button i want that the total cell and the cell where i put 10 in goes empty but the formula stays

 

[dreid1011]

Welcome to the forum.

In your CommandButton_click() event, you would use something like this:

ActiveSheet.Range("B5").Value = ""
ActiveSheet.Range("C6").Value = ""

Now, if the two cells are contiguous, then perhaps this:

ActiveSheet.Range("B5:C5").Value = ""

 

[Thijmen10]

Welcome to the forum.

In your CommandButton_click() event, you would use something like this:

ActiveSheet.Range("B5").Value = ""
ActiveSheet.Range("C6").Value = ""

Now, if the two cells are contiguous, then perhaps this:

ActiveSheet.Range("B5:C5").Value = ""

Are my formulas staying with those codes?

 

[dreid1011]

That depends on what cells the formulas are in. I imagine the cell where you input the 10 is manual input, and then the formula is in the total cell? If that's the case, then just use code for the single cell that will contain the manual input of 10 to clear it out. Then your total cell will recalculate by itself to 0 or potentially a value error. What is the exact formula(s) you are using and what cells are they in? And what specific cells are manual input that should be cleared out when the button is pressed?

 

[Thijmen10]

That depends on what cells the formulas are in. I imagine the cell where you input the 10 is manual input, and then the formula is in the total cell? If that's the case, then just use code for the single cell that will contain the manual input of 10 to clear it out. Then your total cell will recalculate by itself to 0 or potentially a value error. What is the exact formula(s) you are using and what cells are they in? And what specific cells are manual input that should be cleared out when the button is pressed?

Thanks for helping i think i dont need to send the formulas because its solved. Thanks alot!

 

[dreid1011]

Ok, you're welcome.