please help me with the macro. Thanks again!

[pedie]

http://www.mrexcel.com/forum/showthread.php?t=480894

Earlier i had same question but didn't work out. Please design a macro that suppose I have time entered in B1 a time = "8:30:00 AM", when the excel time that is running continiously in name define excel area in "Digital Clock" time match the time in B1 the macro will be trigered by itself and then there will be a pop up with whatever word i have entered in cell B3.

Thanks alot!

PS; Vog, if you are around I have re framed my inquiry. Please assist, thanks alot!

 

[pedie]

<TABLE style="WIDTH: 192pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=256 border=0><COLGROUP><COL style="WIDTH: 48pt" span=4 width=64><TBODY><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD class=xl70 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 192pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 23.25pt; BACKGROUND-COLOR: #75923c" width=256 colSpan=4 height=31 rowSpan=2>[FONT=WST_Swed]3:57:45 AM[/FONT]</TD></TR><TR style="HEIGHT: 10.5pt; mso-height-source: userset" height=14></TR></TBODY></TABLE>
my digitalclock looks like this. and it ticks.

 

[Smitty]

Please continue in your Original thread. It seems like a lot of work's gone into it already.