Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom Format Time Code
Here's my code:
Dim time As Range Dim ws As Worksheet Set ws = ActiveSheet Set time = ws.Range(B10) If time.Value = Format(Range("TimeLeft").Value, "00:00:10:00") Then MsgBox ("Prepare to begin Meeting") End If What I am trying to do is display a message when the clock reached 10 minutes or 00:00:10:00. The format of the cell is dd:hh:mm:ss;@. Thanks in advance. -- Fighting Texas Aggie Class of 2009 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Length of time from date/time custom format | Excel Discussion (Misc queries) | |||
Custom time format help | Excel Discussion (Misc queries) | |||
Custom Cell format to mimic time format | Excel Discussion (Misc queries) | |||
Custom Format time to arc | Excel Discussion (Misc queries) | |||
Custom dat & time code | Excel Discussion (Misc queries) |