I want to write a script that sends a message box on a given day of the week at a specific hour. Monday at 10 a.m., for instance.
Dim time As Range
Set time = Sheets("Main").Range("W11")
If time.Value = "Monday 10:00" Then
MsgBox "Time reminder"
I have a cell in "W11" that is formatted to display the day and time and to match the if function in an attempt to make this work, but it still doesn't appear to want to. I'm not sure what I was doing differently, but I had it almost functioning earlier; however, the message box would appear every time I clicked for a whole minute and wasn't just one instance. It looks like it ought to be really easy.