Vba with three click button help

poem · #9 09-22-2015, 04:45 AM

i appericate you too much you have done .
i mean you code on "Notification".
please browse attachment snap shot .
if you write like this code
Sub pop message _Click() '' notification
Dim i As Long
Dim expdate As String
Dim Edate As String
Edate = Format(Now(), "mm/dd/yyyy")
'' look for expired dates ''
For i = 2 To 9
If DateDiff("d", Cells(i, 2).Value, Edate) <= 30 Then
AND
ForEachcell In C2:C9
IfIsEmpty(cell) Then
cell.Value = MSGBOX
and fill cell with black ground white and word informed

End If
Next i
End Sub

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