ch the Worksheet.Evaluate method
> was fastest on my system (feel free to experiment, or even set to 1 to
> see what happens if that method is always used). Worksheet.Evaluate is
> very fast once it gets going, but it has significant overhead for each call.
>
>
>
> Asa
>
ups.com]
On Behalf Of Aamir Shahzad
Sent: Saturday, May 19, 2012 10:39 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Convert amount to Million
For example I insert the column in sheet it's taking too much time when
running this code otherwise inserting the column is too fast. Theref
* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Convert amount to Million
>
>
>
> ??
>
>
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
>
>
> *From:* Aamir Shahzad
>
> *Sent:* Saturday, M
Can you make it more clear??
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: 19 May 2012 6:52
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Convert amount to
??
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Saturday, May 19, 2012 7:52 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Convert amount to Million
Dear Group,
Following macro is working fine but when run this code, Inser
;
>> Dear Aamir,
>>
>>
>>
>> Can u tell me where will be addins folder?
>>
>>
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Sam Mathai Chacko
>> *Sent:* 01 November 2011
;
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Sam Mathai Chacko
> *Sent:* 01 November 2011 12:41
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Convert amount to Million
>
> ** **
>
> Aamir,
>
>
Dear Aamir,
Can u tell me where will be addins folder?
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Sam Mathai Chacko
Sent: 01 November 2011 12:41
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Convert amount to Million
Aamir,
Please
Anand,
This is difficult for me but only tell me how I recall this macro by means
of add in. When I am creating add in & load into the excel this macro not
converting the amount to million however in the working sheet this is
working fine.
*Private Sub Worksheet_Change(ByVal Target As Range)
Dim
Hi Aamir,
In case you want to create a button in the ribbon it is a bit
difficult in Excel 2007. Somehow you can add a command button which is
available in Developer tab in the ribbon and right click on the button
and assign macro to it.
Hope that helps,
Anand Kumar
On Oct 31, 1:55 am, Aamir Sha
Dear SAM I found my requirement in the link below
http://www.contextures.com/xltoolbar02.html#AddIn
I have also created & Installed 2 buttons but how create more
buttons+assign macros to buttons.
Regards,
Aamir Shahzad
On Sat, Oct 29, 2011 at 8:53 AM, Aamir Shahzad wrote:
> Yes SAM I want to
Yes SAM I want to enable this macro for all excel sheets in shape of add in.
Well .xlam is attached where I am created new 2nd module however your
"Convert to Million" Macro is running fine in sheet but when I enter this
macro into add in file this won't work.
Aamir Shahzad
On Sat, Oct 29, 2011 a
Why do you want this in another add-in? Do you want the feature to be
available in ALL the workbooks that you use?
Also Aamir, a normal add-in does not have the require events to capture a
change in the sheets in another workbook. To get it to run automatically,
you'll need to call an application
how to call? is it not run automatically when enter 1M & enter?
Aamir Shahzad
On Sat, Oct 29, 2011 at 2:52 AM, Sam Mathai Chacko wrote:
> The original code that I gave should have been written within a workbook.
> But now that you are using an add-in, yes you can use it in a different
> module,
The original code that I gave should have been written within a workbook.
But now that you are using an add-in, yes you can use it in a different
module, but for it to run, you will have to CALL it when required.
Sam
On Sat, Oct 29, 2011 at 3:20 AM, Aamir Shahzad wrote:
> Can I create another "M
Can I create another "Module 2" in the same add in & write code there?
Aamir Shahzad
On Sat, Oct 29, 2011 at 2:43 AM, Sam Mathai Chacko wrote:
> Not sure what procedure you require, but if you knew the range, this is how
> you'd call this
>
> your code --
> your code --
> Call
Not sure what procedure you require, but if you knew the range, this is how
you'd call this
your code --
your code --
Call ConvertToMillions(Worksheets("NameOfSheet").Range("A1"))
your code --
Private Sub ConvertToMillions(ByRef Target As Range)
Dim rngCell As Rang
how? procedure required.
On Sat, Oct 29, 2011 at 2:39 AM, Sam Mathai Chacko wrote:
> Yes you can
> Sam
>
>
> On Sat, Oct 29, 2011 at 3:07 AM, Aamir Shahzad
> wrote:
>
>> Can I enter this code with another add in?
>>
>>
>> On Sat, Oct 29, 2011 at 2:27 AM, Sam Mathai Chacko wrote:
>>
>>> Something
Yes you can
Sam
On Sat, Oct 29, 2011 at 3:07 AM, Aamir Shahzad wrote:
> Can I enter this code with another add in?
>
>
> On Sat, Oct 29, 2011 at 2:27 AM, Sam Mathai Chacko wrote:
>
>> Something like this might do the trick
>>
>> Private Sub Worksheet_Change(ByVal Target As Range)
>>
>> Dim rn
Can I enter this code with another add in?
On Sat, Oct 29, 2011 at 2:27 AM, Sam Mathai Chacko wrote:
> Something like this might do the trick
>
> Private Sub Worksheet_Change(ByVal Target As Range)
>
> Dim rngCell As Range
>
> For Each rngCell In Target
> If Right(UCase(Trim(rngCe
Something like this might do the trick
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rngCell As Range
For Each rngCell In Target
If Right(UCase(Trim(rngCell.Text)), 1) = "M" Then
rngCell.Value = Replace(UCase(Trim(rngCell.Text)), "M", "") * 10
^ 6
En
21 matches
Mail list logo
