Re: $$Excel-Macros$$ Excel Pop-ups

2011-07-03 Thread ashish koul
Of *Mahreen Ellahi *Sent:* Sunday, July 03, 2011 5:47 PM *To:* excel-macros@googlegroups.com *Subject:* Fwd: $$Excel-Macros$$ Excel Pop-ups ** ** Hiii Thanks to ST Devi, I have reached up to this level , but the code shows some error now. Can anybody plz help me out. Regards

Re: $$Excel-Macros$$ Excel Pop-ups

2011-06-19 Thread STDEV(i)
please check this vba code, hope it helps.. -Standard Module Sub ExpiryWarning()   ' siti Vi // Jakarta, 19 Jan 2011   '   Dim dTable As Range, t As String   Dim R As Long, N As Long, I As Integer   Set dTable = Cells(1).CurrentRegion   N = dTable.Rows.Count

Re: $$Excel-Macros$$ Excel Pop-ups

2011-06-19 Thread Mahreen Ellahi
Hey thanks it worked. Perfect solution Mahreen On Sun, Jun 19, 2011 at 11:59 AM, STDEV(i) setiyowati.d...@gmail.comwrote: please check this vba code, hope it helps.. -Standard Module Sub ExpiryWarning() ' siti Vi // Jakarta, 19 Jan 2011 ' Dim

$$Excel-Macros$$ Excel Pop-ups

2011-06-18 Thread Mahreen Ellahi
Hii I have a some data with limits expiry on different dates. I want to have popup window to appear whenever the limit is about to expire like 15 to 30 days earlier. Can anyone help me for VBA coding. Regards Mahreen --