I'm trying to work with a toggle button to enter a date into a table when pressed and delete that date if unpressed. I wish I could tie a macro into the state of the toggle button, but it seems I just have to use the On Click event with an if/then macro hoping that the button condition and cell condition don't get out of sync. However, trying to write a macro to handle this doesn't seem to be working. Below is what I've written. I don't get an error. It just doesn't seem to do anything.
Code:Private Sub Toggle96_Click() If Me.Frame_Stripped = Null Then Me.Frame_Stripped = Date Else: Me.Frame_Stripped = Null End If End Sub