Hi Ashish Sorry a few errors in that reply
I think you may be able to use something like Sub test() Dim X As String X = "Test" Shell "cmd /c msg * It is " & X & "'s Birthday today" End Sub Now you will need to get the name of the person from your list and assign it to X instead of Test. To some extent it depends on how hard your network is locked down. First try the sub above and see if it works. Regards David > On 7 June 2012 13:49, Ashish Bhalara <ashishbhalar...@gmail.com> wrote: > >> >> >> ---------- Forwarded message ---------- >> From: Ashish Bhalara <ashishbhalar...@gmail.com> >> Date: Tue, Jun 5, 2012 at 9:52 AM >> Subject: $$Excel-Macros$$ Display message on screen by fulfill condition >> To: excel-macros@googlegroups.com >> >> >> Dear experts, >> >> Do you have any code to display message on screen by fulfill a condition >> in excel. Actually I have salary sheet in which mention all staff's >> birthday and I want to make reminder that on the day of birthday of any >> employee, the message is display either on screen without opening excel or >> in excel sheet. Thanks in advance. >> >> Ashish Bhalara >> >> >> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> ------------------------------------------------------------------------------------------------------ >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> >> >> >> -- >> Thanks & regards. >> >> Ashish Bhalara >> 9624111822 >> >> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> ------------------------------------------------------------------------------------------------------ >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> > > > > -- > David Grugeon > -- David Grugeon -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
