Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() hie guys, just started Excel programming & I could use some help from you gurus I'm creating a reminder using excel & basically I'll input the dates & events in the sheets. At the moment, I'm stuck in playing with the DATES. I'm placing my dates on A1 & events on B1 What I would like to do is: With worksheets("Sheet1") if range("A1").value = date then msgbox("Please do this:" range("B2")) else msgbox("Pending") endif end with I've linked this macro to a button, but whenever I press the button, it will only display "Pending" although I've set the date of the events to the current date!! Please help!! Thanks & Regards, Xswoosh ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
reminder in excel | Excel Discussion (Misc queries) | |||
Excel: Reminder/Pop-up message | New Users to Excel | |||
Reminder in Excel? | Excel Worksheet Functions | |||
Reminder in excel | Excel Discussion (Misc queries) | |||
add a tickler reminder in Excel? | Setting up and Configuration of Excel |