*
Dear User,
I created one excel User Form in which i given the reminder.
In Reminder (Text Box) when user put todays date, the date after 8 days get
displayed in Due Date (Text Box reminder) which is not editable for every
individual row.
On Due Date a user should get the Pop Up Box of Warning.
Can you please help me out in above query.
Waiting for reply,
Nandkumar
*
On Tue, Sep 13, 2011 at 5:34 PM, NOORAIN ANSARI <noorain.ans...@gmail.com>wrote:
> Dear Nandkumar,
>
>
> try it......
>
> Sub color_befor8days()
> Dim i As Integer
> Dim j As Integer
> j = WorksheetFunction.CountA(Sheet6.Range("E:E"))
> For i = 2 To j
> If Day(Sheet6.Range("E" & i) - Now()) = 8 Then
> Sheet6.Range("E" & i).Interior.Color = vbRed
> End If
> Next
> End Sub
>
> --
>
>
>
> Thanks & regards,
> Noorain Ansari
> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
>
>
> On Tue, Sep 13, 2011 at 9:49 AM, Nandkumar kakvipure <
> nandkumar.hindust...@gmail.com> wrote:
>
>> hiiiiiiiiii
>>
>> dear, i am sending u the one XLS sheet with this mail.as we discuss
>> yesterday in this sheet u will find the all data & the due date column which
>> should going to popup or should be get highlighted before 8
>> days.................if its possible with any formulas as u said it going to
>> helpful for me...........so let me know ASAP
>>
>> Wating for u r reply..............
>>
>>
>>
>> Thanks & Regards,
>> Nandkumar
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
