• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA output to desktop?

Jeff999

New Member
I have a spreadsheet that is a To Do list. Is there a simple way with VBA to send an alert to the desktop when tasks are overdue, assuming that the spreadsheet starts with Windows and is minimized in the taskbar?

(To clarify, my question is about sending information to the desktop with VBA. It's not a problem to figure out if there are overdue tasks.)

Some possibilities might be to change the color of the icon in the taskbar depending on the status of the tasks, or to have a red graphic appear in the taskbar or elsewhere when there are overdue tasks, etc.

Thanks.
 
How about a simple If--Then statement

Code:
If something then

Msgbox "Something Happened"

End if
 
Back
Top