|
|
#1
09-19-2015, 03:34 AM
|
|||
|
|||
Vba with three click button help
GOOD AFTER NOON,
PLEASE MY DEAR I am looking for Excel VBA three code counter that can count the number of expiry, EXPIRE WITHIN THE NEXT 30 DAYS list of date obtained by the name in an ROP expiry and msg box appearance if not word informed fill it at status when the name under expiry within next 30 days . Date is now 19/09/2015 FRIST BUTTON Expiry---------------- fill back ground cell red SECOND BUTTON EXPIRE WITHIN THE NEXT 30 DAYS----------fill back ground cell yellow THREE SCECOND NOTICICATION …….. MsgBox("The rop licence for " & Name & " will expire in " & Diff & appearance if not word informed fill it at status when the name under expiry within next " days.", vbCritical, "Warning") 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How to import excel calender data into outlook - with a click of a button
|
levrone | Excel | 24 | 10-01-2021 05:33 AM |
| ActiveX Command Button disappears after click | Bengt | Word VBA | 1 | 09-18-2013 12:42 PM |
| Animations on Button Click | dvogler | PowerPoint | 1 | 03-01-2012 12:46 AM |
| Word doc bug when closing from userform command button click macro | Joe Patrick | Word | 1 | 07-05-2011 08:53 PM |
| Button click event from a noob | jsampson | Outlook | 0 | 10-12-2010 01:48 PM |
Windows XP 
Office 2007
Threaded Mode