Hi Ramesh, I guess if you only want time stamp then you can also use the below formula in column B.
=IF(A1>0,TEXT(TODAY(),"mm/dd/yy"),"") Regards, Deepak On Thu, Sep 30, 2010 at 9:02 PM, Paul Schreiner <schreiner_p...@att.net>wrote: > Where did you place it? > It belongs in the Sheet module for the specific sheet. > Not a "standard" module, or the This workbook module. > > > *From:* Ramkesh Maurya <sunscel...@gmail.com> > *To:* excel-macros@googlegroups.com > *Sent:* Thu, September 30, 2010 10:51:38 AM > *Subject:* Re: $$Excel-Macros$$ > > Hi Dave, > > I copied the code but unable to execute it, Can u please tell me where I am > wrong? > > Regards > Ramkesh > > On Thu, Sep 30, 2010 at 5:58 PM, Paul Schreiner <schreiner_p...@att.net>wrote: > >> I would use a sheet change event: >> >> '---------------------------------------------------------------------------------------- >> Private Sub Worksheet_Change(ByVal Target As Range) >> Dim Targ As Range >> For Each Targ In Target >> If Targ.Column = 1 Then >> Application.EnableEvents = False >> If (Targ.Value & "X" = "X") Then >> Cells(Targ.Row, "B").ClearContents >> Else >> If (Cells(Targ.Row, "B") & "X" = "X") Then Cells(Targ.Row, >> "B") = Now >> End If >> Application.EnableEvents = True >> End If >> Next Targ >> End Sub >> >> >> '---------------------------------------------------------------------------------------- >> >> >> >> Paul >> >> >> *From:* Ramkesh Maurya <sunscel...@gmail.com> >> >> *To:* excel-macros@googlegroups.com >> *Sent:* Wed, September 29, 2010 2:36:06 PM >> *Subject:* Re: $$Excel-Macros$$ >> >> Dear Dave, >> >> Thanks for paying attention, >> >> Yes I am allowed to use Macro & I want the date in Col B only when the >> adjecent cell Col A received some text for the first time >> >> Regards >> Ramkesh >> >> On Wed, Sep 29, 2010 at 7:50 AM, Dave Bonallack < >> davebonall...@hotmail.com> wrote: >> >>> A further question: Do you want the date in Col B to enter only when the >>> adjacent cell in Col A receives text for the first time, or any time the >>> adjacent Col A cell is changed? >>> >>> Regards - Dave. >>> >>> ------------------------------ >>> Date: Tue, 28 Sep 2010 23:40:09 +0530 >>> Subject: $$Excel-Macros$$ >>> From: sunscel...@gmail.com >>> To: excel-macros@googlegroups.com >>> >>> Dear All, Xl Mania(s) >>> >>> I really appreciate this group for learning >>> I have lrarnet a lot of tricks from this group which enabled me to come >>> of with flying colours.Today i am posting my first query briefing in below >>> lines----------- >>> >>> 1- I fill some text in column A (say) >>> 2- I want that the date of filling data should appear in column B >>> (beside the column A) >>> >>> Now condition is ----- >>> >>> 3 -Date in column B should not be updated by re-calculation nature of >>> Excel or user >>> >>> >>> I know that anybody will help me so thanks in advance ! >>> >>> -- >>> >>> Ramkesh >>> >>> >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts >>> >> >> >> >> -- >> >> Ramkesh >> 9990260398 >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts >> > > > > -- > > Ramkesh > 9990260398 > > -- > > ---------------------------------------------------------------------------------- > 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts > > -- > > ---------------------------------------------------------------------------------- > 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- Regards, Deepak Rai -- ---------------------------------------------------------------------------------- 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
