Vivek,
Can u give me the code.The portal which u hav referred is a payable site.
Regards,
Bharghav R
On Tue, Aug 25, 2009 at 10:18 AM, vivek agrawal
vivek.agrawa...@gmail.comwrote:
hi
the below web page will help you to set tab order for the text boxes...
Its starnge to c tht it works in my system but not in my colleagues system.I
guess its not a problem with the code rather with his system.Anyways thanx
for the code..
On Tue, Aug 25, 2009 at 10:39 AM, vivek agrawal
vivek.agrawa...@gmail.comwrote:
Hi
Shell F:\Running Apps\FTP
Hi
See the attached image which contains the instructions on how to change the
tab order of objects on a user form. in the image Info Survey
refers to your user form...
Hope that will help
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving
Hi Everybody,
I need help with below Vlookup function in macro.
Following is the code I am presently using
ActiveCell.FormulaR1C1 = =VLOOKUP(RC[2],'[SAP Codes.xls]Sheet1'!C2:C4,3,0)
But above formula prompts me every time to locate the SAP code worksheet. Is
there any way I can put the path of
Hello JM
The custom addins can be added in Excel 2007 through the Office Button. \
Click on Office Button - Excel Options - Addins - Manage Addins.
Anil Kumar Agarwala
Anil Agarwala Co.
Chartered Accountants
3rd Floor, Adiba Mansion
Maszid Lane, Kamarpatty
Fancy Bazar
Guwahati : 781001
Assam
Hello JM
The custom addins can be added in Excel 2007 through the Office Button. \
Click on Office Button - Excel Options - Addins - Manage Addins.
Anil Kumar Agarwala
Anil Agarwala Co.
Chartered Accountants
3rd Floor, Adiba Mansion
Maszid Lane, Kamarpatty
Fancy Bazar
Guwahati : 781001
Assam
Hi Venkatesh i have uploaded the File jsut now ( 02:00 PM IST) in the
Group folder http://groups.google.com/group/excel-macros/web/sample%20sheet.xls
Please let me know the answer
On Aug 24, 9:53 am, Suhas chet...@gmail.com wrote:
Hi Venkatesh,
How can i send the attachement, i cant find
Vivek,
I have not used the user form.I have inserted active x controls.Have used
text boxes and comboboxes.Want to hav tab functionalities for the active x
controls.
Regards,
Bharghav R
On Tue, Aug 25, 2009 at 12:27 PM, vivek agrawal
vivek.agrawa...@gmail.comwrote:
Hi
See the attached
Could you paste your Macro Codes here and probably it will be easy to
identify solution.
May be your macros are event based.
Kamal
On Mon, Aug 24, 2009 at 5:09 PM, Joseph Choi jsk.c...@gmail.com wrote:
you may need to save the user input state of your controls (combo box,
listbox) and save it
Hi Putta,
Attached herewith is the solved spreadsheet containing two possible
scenarios. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Aug 4, 2009 at 2:38 PM, Putta Madaiah
Hi Shivashankar,
I have given out the solution in the attached spreadsheet. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Aug 4, 2009 at 6:14 PM, shivashankar katageri
Hi Suresh.. the Brave man.!!
Attached workbook has the solution to your query. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Aug 25, 2009 at 5:06 PM, suresh k brave.sur...@gmail.com wrote:
Ok..I think tomorrow, we can discuss on this over Gtalk.
If you want you can draft your queries as well and sent that to the group.
Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Aug 25, 2009 at
Hi Vidyut,
Solution is attached with this email. thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Aug 25, 2009 at 2:23 PM, vidyut more vidyutm...@gmail.com wrote:
plz find attd. excel file. i
I'm looking for an efficient way to download data from Reuters into
vba.
Downloading into a workbook cell is easy enough, but I want to avoid
using reuters links in my spreadsheet, as it slows things down
considerably.
At the moment I'm using the following code in vba:
ReutersData =
Hello Experts,
I am looking for a way to start a macro by clicking on a specific cell
in the spreadsheet. The macro have to run each time the value in the
cell is changed.
Is this possible???
Thank in advance for the help
Kind regard
Hans Dijkstra
Hi
Anish Shrivastava.
its cool
Thnaks a lot
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
can i use this formula to another sheet extract data from another sheet.
-- Forwarded message --
From: Anish Shrivastava anish@gmail.com
Date: Tue, Aug 25, 2009 at 3:32 PM
Subject: Re: $$Excel-Macros$$ Help regarding formula
To: excel-macros@googlegroups.com
Cc:
Thank you Dilip, I appreciate your efforts.
Rgds- Putta
On Tue, Aug 25, 2009 at 4:35 PM, Dilip Pandey dilipan...@gmail.com wrote:
Hi Putta,
Attached herewith is the solved spreadsheet containing two possible
scenarios. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile:
Can anyone provide me the formula for below query.
Report Date Total Logged Time at Work Hrs 7/2/2009 8.86 7/2/2009 9.03
7/2/2009 7.92 7/2/2009 9.02 7/3/2009 9.05
Answer should be 26.91. Excluding the value less than 8.00 hrs and it should
calculate only for one day(7/2/2009).
I have tried
Hi All,
Hope you are well.
I would like to ROUNDUP the figure below
9,235,200.23 € to 9,500
Can you please advise ?
Thanks
--
Regards
Nourredine BELHAJ
+41783081988
+33665248617
--~--~-~--~~~---~--~~
Here is the macro attached to the command button that populates the
comboboxes:
Private Sub CommandButton3_Click()
Sheet2.Include1.Value = False
Sheet2.Include2.Value = False
Sheet2.Include3.Value = False
Sheet2.Include4.Value = False
Sheet2.Include5.Value = False
Sheet2.Include6.Value =
I will use conditional formatting in the 2nd and 3rd columns instead.
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free
I have a worksheet where users log daily
activities. There are three columns where
they need to respond either Yes or No
to these activities based on a specific question.
For ease of entry I have made a data validation
from a list with either Yes or No as the options for
each cell in the
Absolutely!
What you're looking for is a specific type of macro (or subroutine)
called an Event.
There are lots of kinds of events.
the workbook_open event runs when a workbook is open.
the workbook_activate or workbook_deactivate events run when you
switch between windows.
What you describe
Try =SUMIFS (not SUMIF, but SUMIFS)
the plural means multiple conditions!!!
the function Wizard makes it very easy to use.
But your formula becomes:
=SUMIFS(B2:B6,A2:A6,7/2/2009,B2:B6,8)
Sums B2-B6, if A2-A6 is 7/2/2009
and if B2-B6 is 8.
hope this helps.
Paul
Hey Putta, thanks for the appreaciting note. . !!
Warm Regards,
DILipandey
On 8/25/09, Putta Madaiah puttamada...@gmail.com wrote:
Thank you Dilip, I appreciate your efforts.
Rgds- Putta
On Tue, Aug 25, 2009 at 4:35 PM, Dilip Pandey dilipan...@gmail.com wrote:
Hi Putta,
Attached
I think Dilip has already provided the solution.
plese refer to attached file.
On Tue, Aug 25, 2009 at 5:53 PM, suresh k brave.sur...@gmail.com wrote:
Can anyone provide me the formula for below query.
Report Date Total Logged Time at Work Hrs 7/2/2009 8.86 7/2/2009 9.03
7/2/2009
I solved the problem my self, like this:
Txt1 = Txtbox1.Value
Txt2 = Txtbox2.Value
Txt3 = CDec(Txt1) + CDec(Txt2)
TxtTotal.Text = Format(Txt3, ###0.00)
It works like a charm.
--~--~-~--~~~---~--~~
Hello Team,
How do i rank only positive numbers. Plz help me on formula.
Example
Amount Rank
200 2
100 3
-50NA
10 4
-5 NA
3001
--~--~-~--~~~---~--~~
Hi
attached is the solution to your query
Hope it helps
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Tue, Aug 25, 2009 at 9:52 PM, vinod rao vinod.ma...@gmail.com wrote:
Hello Team,
How do i rank only positive
On Tue, Aug 25, 2009 at 9:52 PM, vinod rao vinod.ma...@gmail.com wrote:
Hello Team,
How do i rank only positive numbers. Plz help me on formula.
Example
Amount Rank
200 2
100 3
-50NA
10 4
-5 NA
3001
i
On Aug 25, 9:39 pm, NOURREDINE BELHAJ nourredine.bel...@gmail.com wrote:
Hi All,
Hope you are well.
I would like to ROUNDUP the figure below
9,235,200.23 € to 9,500
Can you please advise ?
Thanks
--
Regards
Nourredine BELHAJ
+41783081988
+33665248617
Hi Nourredine,
A
Hi Vinod,
Attached file has three different solution scenarios to your query. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 8/25/09, vinod rao vinod.ma...@gmail.com wrote:
Hello Team,
How do
34 matches
Mail list logo