Good morning, I am looking for help to formulate VBA Code. I need to clear the contents of Columns C:F if Column F is less than today's date. Can anyone help me with this? Please and than... heathermarie923 Without clicking the button? Private Sub Worksheet_Activate...
Add the following code at the end of the previous code. Sub D_Col() Dim C_Month As Integer Dim C_Date As MSForms.CommandButton For C_Month = 1 To 42 Set C_Date = Me.Controls("CommandButton" & C_Month) C_Date.BackColor = VBA.RGB(217, 210, 233) C_Date.Enabled = True Next ...
Good morning, I am looking for help to formulate VBA Code. I need to clear the contents of Columns C:F if Column F is less than today's date. Can anyone help me with this? Please and thank you in advance!