RE: $$Excel-Macros$$ Event macro request

2012-04-04 Thread Rajan_Verma
Put this code in Worksheet Module, it will not work in normal module.. Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mangesh Dayne Sent: Apr/Wed/2012 06:35 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Event macro request

RE: $$Excel-Macros$$ Event macro request

2012-04-04 Thread Rajan_Verma
: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sharath Sambrani Sent: Apr/Wed/2012 06:13 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Event macro request Thanks Rajan, It worked! Appreciate your quick reply. Cheers, Sharath On

Re: $$Excel-Macros$$ Event macro request

2012-04-04 Thread Mangesh Dayne
> >>> Application.EnableEvents = 0 >>> >>> If Target.Column = 1 Then >>> >>> Target.Value = (Target.Value * 12) / 100 >>> >>> End If >>> >>> Application.EnableEvents = 1 >>> >>> **** >&

Re: $$Excel-Macros$$ Event macro request

2012-04-04 Thread Sharath Sambrani
* >> >> Target.Value = (Target.Value * 12) / 100 >> >> End If >> >> Application.EnableEvents = 1 >> >> >> >> End Sub >> >> ** ** >> >> ** ** >> >> Rajan >> >> *F

Re: $$Excel-Macros$$ Event macro request

2012-04-04 Thread Sharath Sambrani
lto: > excel-macros@googlegroups.com] *On Behalf Of *Sharath Sambrani > *Sent:* Apr/Wed/2012 11:48 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Event macro request > > ** ** > > Hello Experts, > > ** ** > > I have a quick question for

RE: $$Excel-Macros$$ Event macro request

2012-04-04 Thread Rajan_Verma
@googlegroups.com] On Behalf Of Sharath Sambrani Sent: Apr/Wed/2012 11:48 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Event macro request Hello Experts, I have a quick question for you. I am looking for a event macro. Whenever someone inputs a value in any cell under a particular

$$Excel-Macros$$ Event macro request

2012-04-04 Thread Sharath Sambrani
Hello Experts, I have a quick question for you. I am looking for a event macro. Whenever someone inputs a value in any cell under a particular column (say column A) and hits ENTER, the value in the same cell should calculate as (Value x 12)/100. For example, I enter a value in cell A2, the result

$$Excel-Macros$$ Event macro request

2012-04-04 Thread Sharath Sambrani
Hello Experts, I have a quick question for you. I am looking for a event macro. Whenever someone inputs a value in any cell under a particular column (say column A) and hits ENTER, the value in the same cell should calculate as (Value x 12)/100. For example, I enter a value in cell A2, the result