Is there a simple way to reset a form when a value in a particular cell is changed?
I was thinking I'd use Change Event to trigger the reset to happen... start with this:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$T$2" Then
...but after that, can I tell it to reset the form to it's original format and rerun the macro that formats it? (I'd have to reset cells whose formulae have been overwritten with copy/paste values, so I couldn't just update values)
I was thinking I'd use Change Event to trigger the reset to happen... start with this:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$T$2" Then
...but after that, can I tell it to reset the form to it's original format and rerun the macro that formats it? (I'd have to reset cells whose formulae have been overwritten with copy/paste values, so I couldn't just update values)