Anda belum searching di old posting milis XL-mania ataupun belajar-excel ?
On 11/18/10, ratu elissa wrote:
> hot to create time update per second in vba
>
> --
> --
> Some important links for excel users:
> 1. Foll
A lot of information would be available on a google search. Depending
on how you want to use it, like in a cell or on a user form the code
would change by a bit.
If you can provide details someone can surely provide the code. It
would be in a module and code would be something like:
Public TimeOnO
Dear Group,
I quite often receive queries from the members who want to learn VBA
macros but not finding resources to learn.
There is a good news for such people.
A Web based VBA Coaching Program is launched today by John Franco
( Same person who shared his ebooks free for this group recently).
IS THERE ANY GOOD PERSON/INSTITUTE TO LEARN ADVANCE EXCEL AND VBA MACROS AT
JAIPUR.
PLEASE SUGGEST ME.
AWAITING FOR YOUR RESPONSE.
REGARDS
AMIT
--
--
Some important links for excel users:
1. Follow us on TWITTER
Hi Experts
I am waiting for over 10 days for the below request to convert PDF
file to RTF file format.
For better understanding Please find the below.
1. Usually I will recieve n number of PDF per day.
2. I have to change the file in to RTF format (Ms WOrd).
3. Now I am open the PDF file and cop
hot to create time update per second in vba
--
--
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.lin
Mr. Wallace,
Thanks for your query. Well, don't bother your English is fine. I'm
taking your problem and hope my answer is useful to you. Please adjust
it according to your needs, I tried and it was working as per my
perception.
Sub abc()
For i = 1 To 45
..Width = _
..Width
no idea ? Or may i learn english before posting my questions ? lol
José
On 15 nov, 01:13, Alfred WALLACE wrote:
> hello to all !
>
> I'm trying to make a shape in an userform,
> and, to make longuer longuer this shape
> like a progress bar for a time duration.
>
> for exemple, my duration is 45
Your formula for row 3 would look like:
=IF(C3="USD",VLOOKUP(A3,Data!A:E,5,FALSE),VLOOKUP(A3,Data!A:E,4,FALSE))
Paul
>
>From: Jagadeesh B S
>To: excel-macros@googlegroups.com
>Sent: Wed, November 17, 2010 7:45:42 AM
>Subject: $$Excel-Macros$$ Help required for formule
>
>
>Hello Friends
>I need
First of all,
you can NEVER return a "2" which represents:
"If every year since the max experienced a percent increase"
Because: If you find the MAX of the 5 years,
then check it against the following year and the following year
there was an INCREASE, then evidently you didn't find the MAX correc
Hello Friends
I need a formula or macro( preferabley formule) need to prepare this report
.
I need a formula which should get the details for the account # mentioned in
the column A with the reference to the currency,form the sheet DATA, if the
currency is USD It should pull the value in the colu
>
> can you attach sample data. also is the data that you want to compare will
> have unique values.
>
>
>
> --
> Date: Fri, 12 Nov 2010 13:09:02 +0530
> Subject: $$Excel-Macros$$ VBA Code Required
> From: shrinivas...@gmail.com
> To: excel-macros@googlegroups.com
>
>
>
Hi Rajesh,
I modified your code. You may try these codes:
For Sheet1: Event Macro
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.EnableEvents = False
Columns(3).Interior.ColorIndex = xlNone
Cells(ActiveCell.Row, 3).Interior.Color = vbYellow
Applica
Hi Jim,
Forgive me, if I've not understood it correctly but you can achieve
the same task using Find method. Press Ctrl+F and search the number.
Why you need a macro/custom formula ?
Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft C
Hi Kurt,
Try this:
=ABS(MATCH(MAX(A1:E1),A1:E1,0)-COUNT(A1:E1))
Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com
15 matches
Mail list logo
