Formula to temporarily clear contents of cell when button is clicked..?

[jwd210]

Hello,

I would like to update my budget worksheet that uses a drop-down menu with a button instead for clearing contents of my cells.

Currently I am using the formula =IF(F28="Yes","",D28) to clear the contents of a cell so I can show an item paid when "Yes" is selected from the drop down menu, and when I need to reset it for the next month I change the drop down menu to "No" and it defaults to the value of another cell.

How can I utilize a button instead of having to keep using drop down menus? Would like to put in a button that changes color when activated and can be reset by clicking it again or a master button that will reset all buttons in a range...


Thank you,

JW

[José Augusto]

Hi
Try this
Select F2:F30
Insert "No" in formula bar and press CTRL+ENTER

[ben_hensel]

You mean a VBA entity or do you want to keep away from XLSM files?

[jwd210]

Either way, whichever is easiest.

All I have been able to do so far is go to developer tab -> insert -> button (form control), and is as far as I have got.

Thanks,

[jwd210]

Ok, seems I got it to work. Here's the code I came up with. However, can I get some help with resetting the value of the buttons in range from E8:E16 back to default (false) by having another button to "reset" them?

Private Sub ToggleButton1_Click()
If ToggleButton1.Value = True Then
Range("c9").Value = ""
Else
Range("c9").Value = Range("d9").Value
End If
End Sub