Re: $$Excel-Macros$$ Counter in a Cell
Hi Daniel Wow, works wonderfully well. Very much appreciated. Regards Charlie On Sun, Sep 4, 2011 at 11:54 PM, Daniel dcolarde...@free.fr wrote: See attached workbook. ** ** HTH ** ** Daniel ** ** *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] *De la part de* Cab Boose *Envoyé :* dimanche 4 septembre 2011 03:05 *À :* excel-macros@googlegroups.com *Objet :* Re: $$Excel-Macros$$ Counter in a Cell ** ** Hi Everbody Thanks for all your options. I would like to explain a little more. I want a small 5 pad keyboard to plug usb into laptop. Operator will not necessary have access to screen. The operator will just use up or down button to change the speed. So the H11 will need to be frozen I guess and then count the ups and downs and show a number in that cell. Daniel - your macro looks like doing as required, but I have tried with cursor in H11 and press the up or down, message comes up with unable to find macro. Now I have your second emailed macro in the Wookbook module. Do I still need some of the macro in the first email in a module? Attached workbook as I have at the moment. Appreciate all your work everyone. thanks Charlie Harris On Sun, Sep 4, 2011 at 3:18 AM, Excel Inspiration xcel.inspirat...@gmail.com wrote: Mr.Charlie, Please find the attached file. I have used Spin button (Form Control). It can be used another sheet linked with sheet 1 – H11 as you requested. *- Xcel Inspiration* *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Cab Boose *Sent:* 03 September 2011 05:13 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Counter in a Cell Hi In attached Sheet1, I want the cell to count from 0 to 16 up and down in between. The count is of times up arrow and down arrow are pressed. To set speed from, 0 to 16 for model railroad project. Your advice appreciated. Thanks Charlie Harris -- -- 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/discussexcel -- -- 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/discussexcel ** ** -- -- 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/discussexcel -- -- 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/discussexcel -- -- 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 @
$$Excel-Macros$$ Re: Doesn't this mean?
If (Range(c32) Range(c33)) Then On Sep 5, 6:06 am, David Lanne djl99_28...@yahoo.com wrote: Sub OTX() ' ' OTX Macro ' ' If (c32 c33) Then End If If (c32 = c33) Then Range(g32:g33).Select Application.Run OT End If End Sub Doesn't this mean if c32 doesn't equal c33 nothing happens,if c32 equals c33 then it runs OT. Right now it runs OT whether c32/c33 are equal or not. Thanks, David Lanne -- -- 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/discussexcel
$$Excel-Macros$$ Re: write and read cookies through vba.
Hi Expert, still waiting for ur solution On Fri, Sep 2, 2011 at 4:12 PM, Divaker Pandey divake...@gmail.com wrote: Hi Expert. Is there any way to write and read cookies through vba. Thanks in advance. Divaker -- -- 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/discussexcel
$$Excel-Macros$$ Fwd: mis executive, chennai, CONTRACT 2 HIRE
- Original message From:Source One Management Services Pvt.Ltd farhee...@msourceone.com Date: 5 Sep 11 12:33:34 Subject: mis executive, chennai, CONTRACT 2 HIRE To: The sender of this email is registered with Naukri.com as Source One Management Services Pvt.Ltd Dear Candidate,Hi ! Hope you are doing well !! This is Farheeen from SourceOne. Source One (www.msourceone.com) one of the fastest growing company from India needs many candidates on mis location: chennai with 3-6 years of experience Only those candidates who can join us in 10days notice period after offer, should apply. Your employment with Source One would be permanent after selection and would be deputed at multi b$ MNC for a long term project. Salary and long term career opportunity with Source One would be excellent. Kindly send your updated CV with below input if you would be interested for this opportunity. Your Contact Number: Present Company Name location: Total Exp : Date of Birth: Are you working at present (Y/N): If not please specify reason for not working: Present Employment (Permanent or Contract): Current Salary: Expected minimum salary: What is your current Notice Period: Willing to join Source One in 7-10 Days or Immediate, please specify: Please specify your reason for change: Willing to relocate. Thanks Regards, _ Farheen S Source One Management Services Pvt Ltd, E-Mail:farhee...@msourceone.com; URL : www.msourceone.com, www.sourceone.co.inIs this job relevant to you? Yes No Your feedback would help us in sending you the most relevant job opportunities Disclaimer: The sender of this email is registered with naukri.com as Source One Management Services Pvt.Ltd (f...@msourceone.com, *, BANGALORE, Karnataka - 560001) using Naukri.com services. The responsibility of checking the authenticity of offers/correspondence lies with you. If you consider the content of this email inappropriate or spam, you may:Report abuse by forwarding this email to: compliance@naukri.comYou can also Block this Company from searching your resume in the database. Advisory: Please do not pay any money to anyone who promises to find you a job. This could be in the form of a registration fee, or document processing fee or visa charges or any other pretext. The money could be asked for upfront or it could be asked after trust has been built after some correspondence has been exchanged. Also please note that in case you get a job offer or a letter of intent without having been through an interview process it is probably a scam and you should contact compliance@naukri.comfor advise. To be on the top of Employer's Resume Search Update Your Resume Now Your Resume has only 30 seconds to impress a Recruiter. Get your resume written by Experts. Call 1800-102-5557 now! (Toll-Free) Dear *venkat1.sql!* Get Yourself a cool, short *@in.com* Email ID now!http://mail.in.com/mails/new_reg.php?utm_source=inviteutm_medium=outgoing -- *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* * * * * -- -- 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/discussexcel
Re: $$Excel-Macros$$ Vlookup with more than one condition
Dear MSEXL Learner Correcting a mistake won't be treated as hurting -: I am fully agree with u but u can correct a mistake by polite way (Never create and suggest formula's based on the articles you read in internet or book, understand the concept how the functions are working and it's concept then only you can able to give exact solution. ) .Please dont think that u only can understand the concept of Excel formula Mr. Noorani is one of the most helpful member in the group I think there is no as such platform for behaviourl aspect Still if u dont like such suggestion Iam really sorry for that Shrinivas On Mon, Sep 5, 2011 at 10:40 AM, Ms-Exl-Learner . ms.exl.lear...@gmail.comwrote: Hi Mr. Shrinivas, Correcting a mistake won't be treated as hurting and if you feel like that then it's your way of thought and I don't want to comment about it. Real experts never like to see wrong answers getting delivered to the questioners and that was I did. If I am providing a wrong solution, then anyone can criticize my solution and I am always welcome to accept and learn from them. Debate on excel will bring new ideas / techniques and which will yield better results rather than redirecting and providing wrong answer to the questioner. At the same time I am not responsible for your feelings and I don't want to waste my time in discussing and giving reply for your own feelings which is not related to excel. Better you can find any mistakes in my excel solutions and criticize it here which will be good for us and others. If you want to criticize something not related to excel then please don't include me and my name in your post and this is not the place to discuss. Hope that make sense! --- Ms.Exl.Learner --- On Sat, Sep 3, 2011 at 1:03 PM, Shrinivas Shevde shrinivas...@gmail.com wrote: Dear All I am a member of this group for last more than 2 years. I can proudly say that u will find the solutions(not solution) for all u r problem. By reading the above mail (from Noorani and Excel Learner) I got some different feeling.So my suggestion is dont critise any one Dont write any mail which will hurt someone Shrinivas On Sat, Sep 3, 2011 at 6:07 AM, Ms-Exl-Learner . ms.exl.lear...@gmail.com wrote: I am tired... --- Ms.Exl.Learner --- On Fri, Sep 2, 2011 at 11:48 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear MS.EXL.Learner, Please see attached sheet... ** Dear i better understand work and Concept of below mentioned functionsi never denied to differencition between each functions. but at a time we can use a function for multiple purpose. * * *[vlookup, Index-Match, Offset-Match]* and *[Sumproduct, Sumifs, Dsum]* . Thanks for your suggestion.. -- *Thanks regards,* *Noorain Ansari* *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Fri, Sep 2, 2011 at 11:11 PM, Ms-Exl-Learner . ms.exl.lear...@gmail.com wrote: Hi Noorain Ansari, Case-1 I have attached the same file for your reference and I have not changed anything on it just created a duplicate data. Now look at the excel file and see what are all the results your formula is deriving. Whether all the results are same? Take my previous mail and read it once again which is elaborated clearly without the help of the above attachment about the differences *[vlookup, Index-Match, Offset-Match]* and *[Sumproduct, Sumifs, Dsum]*. Case-II I know sumproduct very well and the method how we are using the function will differentiate the sumproduct from other functions. But you have used the sumproduct for a single cell, which can be done using the simple IF function and there is no need to go for sumproduct. I just wanted to highlight it to you, and that was I did. Never create and suggest formula's based on the articles you read in internet or book, understand the concept how the functions are working and it's concept then only you can able to give exact solution. Let me know if you need any further clarification. --- Ms.Exl.Learner --- On Fri, Sep 2, 2011 at 10:38 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Ms-Exl-Learner, Thanks for your valuable suggestion.. Case -I, In case of duplicay all formulas are successfull working except vlookup(vlookup) example. You can see fresh attachement.. Case -II, You can't compare Sumproduct with If function both are different.. Correct Syntex of Formula Should be.. =SUMPRODUCT((C3:C8=G3)*(D3:D8=H3)*E3:E8) .instead of =SUMPRODUCT((F3=J3)*(G3=K3)*H3) another way : *{=LOOKUP(2,1/(C3:C8=G3)*(D3:D8=H3),E3:E8)}* Keep Enjoy, Cheers.. -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Fri, Sep 2, 2011 at 9:51 PM,
$$Excel-Macros$$ processor to slow for proper sequential processing of vba code ?
I am running into the problem that some VBA code is not processed in time before a next statement can be executed. For example i want to put a certain Excel graph into the Windows Clipboard and then echo it in an image control on a userform. After that comes a 2nd graph in another image control and so on. What happens is that the statements for the 2nd graph are not executed properly because the second graph is not put into the Clipboard in time to be echoed into the 2nd image control. This 2nd image control shows the first graph in stead of the 2nd one. My question is if there is a way to make sure that some code is executed properly before continuing with other code? thanks for your kind assistance, JH -- -- 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/discussexcel
RE: $$Excel-Macros$$ Doesn't this mean?
You have to write [C32] and [C33] (or Range(“C32”), Range(“C33”)). C32 is considered a variable name, not a range. HTH Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de David Lanne Envoyé : lundi 5 septembre 2011 07:06 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ Doesn't this mean? Sub OTX() ' ' OTX Macro ' ' If (c32 c33) Then End If If (c32 = c33) Then Range(g32:g33).Select Application.Run OT End If End Sub Doesn't this mean if c32 doesn't equal c33 nothing happens,if c32 equals c33 then it runs OT. Right now it runs OT whether c32/c33 are equal or not. Thanks, David Lanne -- -- 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 http://exceldailytip.blogspot.com To post to this group, send email to mailto:excel-macros@googlegroups.com excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel http://www.facebook.com/discussexcel -- -- 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/discussexcel
Re: $$Excel-Macros$$ Need a help in Combo and Check Boxes
Hi Noorain, This helped me a lot but there is a single case in the code, how to add many cases if the select any other country and opt for other check boxes, please refer to the attachment Please help Thanks Prasad. On Mon, Sep 5, 2011 at 8:34 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Surya, Please see attached sheet if it help.. On Mon, Sep 5, 2011 at 7:06 AM, Mr Excellent suryaprasad...@gmail.comwrote: Hi Group, Need a small help, i have a combo box in the form and when i click on particular name INDIA one of the list box which says Indian currency to be updated should be enabled and the other list box should be disabled and vice versa as well, please help. Thanks, Prasad. -- -- 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/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- 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/discussexcel -- -- 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/discussexcel Currency(1).xlsm Description: Binary data
$$Excel-Macros$$ Report generation for Excel 2003
Hai all gurus. Good evening. I heard that excel is having Report generation option for its database. May I have the add-in to build report for my database ? Hope your kind support for me. -- -- 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/discussexcel
$$Excel-Macros$$ Problem extracting data from multiple columns
Hi All, I have a spreadsheet that can have up to 5 data column entries per row asscociated to a date etc. The problem is there is multiple rows and i really want to move it all into 2 columns and keep the date associated with the data i am moving as i intend to put these in a graph. I could do this manually but there will always be data getting added, so would like to be able to do this with a macro. I have tried using autofilters, offsets, Xlup etc but ii keepcant get it to work, i assume because there is not data in every cellof each column Anyway idoes anyone know how i can make it go across each row in the sheet extract the data and add it into a new row on another sheet whilst retaining the date associated with it. Apologies if this does not make sense, however can send an extract from the main workbook if it helps. Thanks in Advance, Andy -- -- 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/discussexcel
Re: $$Excel-Macros$$ Report generation for Excel 2003
hi, what type of report do you need to create, which is your database.. please provide description about that.. On Mon, Sep 5, 2011 at 4:13 PM, Bheema Shankar shankar.n...@gmail.comwrote: Hai all gurus. Good evening. I heard that excel is having Report generation option for its database. May I have the add-in to build report for my database ? Hope your kind support for me. -- -- 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/discussexcel -- Regards Rajan verma +91 9158998701 -- -- 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/discussexcel
Re: $$Excel-Macros$$ processor to slow for proper sequential processing of vba code ?
application.enableevents=false code block application.enableevents=true -Original Message- From: John Holland Sent: Monday, September 05, 2011 3:28 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ processor to slow for proper sequential processing of vba code ? I am running into the problem that some VBA code is not processed in time before a next statement can be executed. For example i want to put a certain Excel graph into the Windows Clipboard and then echo it in an image control on a userform. After that comes a 2nd graph in another image control and so on. What happens is that the statements for the 2nd graph are not executed properly because the second graph is not put into the Clipboard in time to be echoed into the 2nd image control. This 2nd image control shows the first graph in stead of the 2nd one. My question is if there is a way to make sure that some code is executed properly before continuing with other code? thanks for your kind assistance, JH -- -- 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/discussexcel -- -- 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/discussexcel
Re: $$Excel-Macros$$ Report generation for Excel 2003
You could maybe use a macro or a simple vlookup formula From: Shankar Bheema Sent: Monday, September 05, 2011 8:13 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Report generation for Excel 2003 I am attaching the VBA project and a sample spreadsheet form. I want build a report as attached spreadsheet. On Mon, Sep 5, 2011 at 6:32 PM, rajan verma rajanverma1...@gmail.com wrote: hi, what type of report do you need to create, which is your database.. please provide description about that.. On Mon, Sep 5, 2011 at 4:13 PM, Bheema Shankar shankar.n...@gmail.com wrote: Hai all gurus. Good evening. I heard that excel is having Report generation option for its database. May I have the add-in to build report for my database ? Hope your kind support for me. -- -- 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/discussexcel -- Regards Rajan verma +91 9158998701 -- -- 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/discussexcel -- -- 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/discussexcel -- -- 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/discussexcel
$$Excel-Macros$$ Macro to Copy the sheets from One file to Multiple Files
Dear Experts, I would request a macro, which can copy the Sheets(two) from one Master file to other different Excel Files(12 files). I would appreciate your help in this matter. Thanks, Sridhar BL -- -- 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/discussexcel
Re: $$Excel-Macros$$ Need Formula- Very Very Urgent
Dear Pankaj, Please try itand see attached sheet.. *Function Count_text(s As Range) For i = 1 To Len(s) If VBA.Asc(Mid(s, i, 1)) 65 And VBA.Asc(Mid(s, i, 1)) 90 Or VBA.Asc(Mid(s, i, 1)) 96 And VBA.Asc(Mid(s, i, 1)) 123 Then Count_text = Count_text VBA.Mid(s, i, 1) End If Next Count_text = VBA.Len(Application.WorksheetFunction.Substitute(Count_text, , )) End Function * Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Mon, Sep 5, 2011 at 9:09 PM, Intelligent But Crazy secrets...@gmail.comwrote: Dear Group, Is there any formula which can give the count of alphabets in a cell without space special characters ? -- Pankaj Pandey Bhopal -- -- 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/discussexcel -- -- -- 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/discussexcel Count_Only_Text.xlsm Description: Binary data
Re: $$Excel-Macros$$ Need Formula- Very Very Urgent
Thanks Noorain, for your Quick Help. but actually my requirement is Formula, is there any inbuilt formula or combination of inbulilt formulas?? On Mon, Sep 5, 2011 at 9:09 PM, Intelligent But Crazy secrets...@gmail.comwrote: Dear Group, Is there any formula which can give the count of alphabets in a cell without space special characters ? -- Pankaj Pandey Bhopal -- -- 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/discussexcel -- Pankaj Pandey Bhopal -- -- 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/discussexcel
Re: $$Excel-Macros$$ Macro to Copy the sheets from One file to Multiple Files
Dear Sridhar, Please use below link to solve ur query http://akoul.blogspot.com/search/label/Merge%20Data%20from%20multiple%20workbooks%20for%20specific%20sheets%20only http://akoul.blogspot.com/search/label/Merge%20Data%20from%20sheet%201%20from%20multiple%20workbooks%20to%20single%20workbook On Mon, Sep 5, 2011 at 5:18 PM, SridharBL sridhar@gmail.com wrote: Dear Experts, I would request a macro, which can copy the Sheets(two) from one Master file to other different Excel Files(12 files). I would appreciate your help in this matter. Thanks, Sridhar BL -- -- 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/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- -- 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/discussexcel
Re: $$Excel-Macros$$ Need a help in Combo and Check Boxes
Hi Noorain, Please help Thanks Prasad Sent from BlackBerry® on Airtel -Original Message- From: Mr Excellent suryaprasad...@gmail.com Date: Mon, 5 Sep 2011 17:10:47 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need a help in Combo and Check Boxes Hi Noorain, This helped me a lot but there is a single case in the code, how to add many cases if the select any other country and opt for other check boxes, please refer to the attachment Please help Thanks Prasad. On Mon, Sep 5, 2011 at 8:34 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Surya, Please see attached sheet if it help.. On Mon, Sep 5, 2011 at 7:06 AM, Mr Excellent suryaprasad...@gmail.comwrote: Hi Group, Need a small help, i have a combo box in the form and when i click on particular name INDIA one of the list box which says Indian currency to be updated should be enabled and the other list box should be disabled and vice versa as well, please help. Thanks, Prasad. -- -- 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/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- 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/discussexcel -- -- 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/discussexcel
Re: $$Excel-Macros$$ scrolling and blinking label caption
thank you for replying me. But scrolling means not scroll bar. its the caption text of the label have to move from left to right of the screen. just like marquee function in HTML On Sep 5, 7:52 am, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Bheema, Please see attached sheet it it help to u.. -- Thanks regards, Noorain Ansarihttp://Excelmacroworld.blogspot.com/http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Mon, Sep 5, 2011 at 7:29 AM, Bheema Shankar shankar.n...@gmail.comwrote: hai to all, I need to scroll and blink label caption on the userform. I am using Excel 2003. Pls guide me how to do this ? -- --- --- 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 athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://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/discussexcel Scroll Bar-Label Blinking.xlsm 23KViewDownload -- -- 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/discussexcel
Re: $$Excel-Macros$$ Need Formula- Very Very Urgent
=SUMPRODUCT(LEN(A1)- LEN(SUBSTITUTE(UPPER(A1),CHAR(ROW(INDIRECT(65:90))),))) from http://www.excelfox.com/forum/showthread.php?135-Count-Alpha-In-AlphaNumeric-Text GL On Sep 5, 9:09 pm, Intelligent But Crazy secrets...@gmail.com wrote: Thanks Noorain, for your Quick Help. but actually my requirement is Formula, is there any inbuilt formula or combination of inbulilt formulas?? On Mon, Sep 5, 2011 at 9:09 PM, Intelligent But Crazy secrets...@gmail.comwrote: Dear Group, Is there any formula which can give the count of alphabets in a cell without space special characters ? -- Pankaj Pandey Bhopal -- -- 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 athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://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/discussexcel -- Pankaj Pandey Bhopal -- -- 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/discussexcel
$$Excel-Macros$$ Rajan Verma : Most Helpful Member - August'11
Hello Everyone, Rajan Verma has been selected as 'Most Helpful Member' for the month of August'11 He has posted 152 posts in August 2011 and helped many people through his expertise. He has been consistent contributor to this excel forum and has acheived this recognition for second time consecutively. Thanks to Noorain, Venkat, Sunny(XLS S), Don Guillett, and other folks for helping excel enthusiasts voluntarily !! Keep it up !! Keep posting. Regards Ayush Jain Group Manager Microsoft MVP -- -- 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/discussexcel
$$Excel-Macros$$ Re: Rajan Verma : Most Helpful Member - August'11
Rajan, you make us proud. Thanks for the excellent contribution to this forum. Your dedication and commitment to help the online community has been exemplary. Keep up the good work. Regards, Sam Mathai Chacko (GL) On Sep 5, 10:29 pm, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Rajan Verma has been selected as 'Most Helpful Member' for the month of August'11 He has posted 152 posts in August 2011 and helped many people through his expertise. He has been consistent contributor to this excel forum and has acheived this recognition for second time consecutively. Thanks to Noorain, Venkat, Sunny(XLS S), Don Guillett, and other folks for helping excel enthusiasts voluntarily !! Keep it up !! Keep posting. Regards Ayush Jain Group Manager Microsoft MVP -- -- 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/discussexcel
Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - August'11
Congrate rajan babu... On Mon, Sep 5, 2011 at 10:59 PM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Rajan Verma has been selected as 'Most Helpful Member' for the month of August'11 He has posted 152 posts in August 2011 and helped many people through his expertise. He has been consistent contributor to this excel forum and has acheived this recognition for second time consecutively. Thanks to Noorain, Venkat, Sunny(XLS S), Don Guillett, and other folks for helping excel enthusiasts voluntarily !! Keep it up !! Keep posting. Regards Ayush Jain Group Manager Microsoft MVP -- -- 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/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- -- 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/discussexcel
Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - August'11
Congratulation Rajan Babu also Noorain, Venkat, Don Guillett, and other folks On Mon, Sep 5, 2011 at 10:59 PM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Rajan Verma has been selected as 'Most Helpful Member' for the month of August'11 He has posted 152 posts in August 2011 and helped many people through his expertise. He has been consistent contributor to this excel forum and has acheived this recognition for second time consecutively. Thanks to Noorain, Venkat, Sunny(XLS S), Don Guillett, and other folks for helping excel enthusiasts voluntarily !! Keep it up !! Keep posting. Regards Ayush Jain Group Manager Microsoft MVP -- -- 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/discussexcel -- . -- -- 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/discussexcel
Re: $$Excel-Macros$$ Need Formula- Very Very Urgent
Great Solution SAM On Mon, Sep 5, 2011 at 10:48 PM, GoldenLance samde...@gmail.com wrote: =SUMPRODUCT(LEN(A1)- LEN(SUBSTITUTE(UPPER(A1),CHAR(ROW(INDIRECT(65:90))),))) from http://www.excelfox.com/forum/showthread.php?135-Count-Alpha-In-AlphaNumeric-Text GL On Sep 5, 9:09 pm, Intelligent But Crazy secrets...@gmail.com wrote: Thanks Noorain, for your Quick Help. but actually my requirement is Formula, is there any inbuilt formula or combination of inbulilt formulas?? On Mon, Sep 5, 2011 at 9:09 PM, Intelligent But Crazy secrets...@gmail.comwrote: Dear Group, Is there any formula which can give the count of alphabets in a cell without space special characters ? -- Pankaj Pandey Bhopal -- -- 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 athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://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/discussexcel -- Pankaj Pandey Bhopal -- -- 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/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- -- 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/discussexcel
Fw: $$Excel-Macros$$ Need a help in Combo and Check Boxes
Hi all, Can anyone help me on this?? Regards Prasad Sent from BlackBerry® on Airtel -Original Message- From: Mr Excellent suryaprasad...@gmail.com Date: Mon, 5 Sep 2011 17:10:47 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need a help in Combo and Check Boxes Hi Noorain, This helped me a lot but there is a single case in the code, how to add many cases if the select any other country and opt for other check boxes, please refer to the attachment Please help Thanks Prasad. On Mon, Sep 5, 2011 at 8:34 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Surya, Please see attached sheet if it help.. On Mon, Sep 5, 2011 at 7:06 AM, Mr Excellent suryaprasad...@gmail.comwrote: Hi Group, Need a small help, i have a combo box in the form and when i click on particular name INDIA one of the list box which says Indian currency to be updated should be enabled and the other list box should be disabled and vice versa as well, please help. Thanks, Prasad. -- -- 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/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- 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/discussexcel -- -- 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/discussexcel Currency(1).xlsm Description: Binary data
$$Excel-Macros$$ Re: Apparent corruption with .PageSetup.Zoom
Chris, doesn't look like anything is wrong with your settings. If A3 wouldn't be a problem, try changing the paper size to A3, from A4 Sam On Sep 5, 10:24 pm, Chris Boxall ch...@boxall.info wrote: Apparent corruption with .PageSetup.Zoom I fear that I have corrupted my installation of Excel 2007 (on XP). Symptoms: - Sheets included in a workbook, that also contains my major Excel macro (called 'wttWorkBench') now print slightly smaller. - 'wttWorkBench' operates on (other) pre-existing, separate, spreadsheets correctly. - Copying a sheet from an existing spreadsheet to a new (empty) spreadsheet file results in the print from the new file being a little smaller than the original one (although the data is identical in both sheets). - The reduction in print size is about (perhaps the same) as the .PrintSetup.Zone value of 92 that I have been using. Recent activities: - I have been implementing a VBA print setup SUB within 'wttWorkBench'. I suspect that I did something that has changed an Excel default. When I was developing the print setup SUB, I made some errors with the WITH command. Possibly, I wrote a ZOOM value to a hidden location within EXCEL. Diagnostics: - When I Print (or PrintPreview) the same data, but in the two different worksheets, one is slightly smaller than the other. - When I compare the parameters in 'PrintPreview' they are identical in both worksheets. All values are the same - Scaling; PaperSize being the obvious ones but all margins are also the same. - Checking the WIDTH of the printed area with 'Range'.Width gives the same result from both sheets (794.25). I attach two files: o 'originalZoom' which was created several weeks ago. The sheet is printed at 92% zoom to fit onto one page. o 'testZoom'. This was created as a new, empty workbook today. Then sheet 'EMF-SMF' was copied from 'originalZoom' into 'testZoom'. No changes were made of any sort. Investigation: - I have been unable to locate a way to set a default Zoom. - I suspect that whilst I was developing my code I might have made an error in qualifying my '.PageSetup.Zoom' command. I attach my, now, working SUB below. However, I did have some problems in getting it to work. That is, I may well have executed an incorrect OBJECT on the WITH command. - The normal level of ZOOM that I use is 92%. That is, I need a Zoom setting of 92 to print my spreadsheet on the page. - My code enables me to set different PrintSetup parameters depending on the contents of the sheet. (the variable is 'wttWTT_Type'). PrintSetup values are extracted from arrays of data (defined elsewhere). Solution: Unless I can find how Excel is corrupted, I fear that I shall have to reinstall EXCEL. Perhaps I could simply refrain from creating new workbooks - just copy existing ones and the delete all of the datasheets! May be I could create a new TEMPLATE from an existing workbook. Christopher Boxall (UK) __ My SUB which is now working is: - Slightly adjusted for clarity Public Sub wttPageSetup() ' Set up Printing characteristics (depends on 'wttWTT_Type') With ActiveSheet With .PageSetup Select Case wttWTT_Type Case wttWTT_TypeSvrYear, wttWTT_TypeSvrSpecial .PaperSize = lPaperSizes(wttWTT_Type) ' 9 = 'A4' .TopMargin = dTopMargins(wttWTT_Type) .BottomMargin = dBottomMargins(wttWTT_Type) .CenterHorizontally = bCenterHorizontallys(wttWTT_Type) .CenterVertically = bCenterVerticallys(wttWTT_Type) .Orientation = iOrientations(wttWTT_Type) ' 2=Landscape ('xlLandscape' only avail Excel 2007 and above) .Zoom = iZooms(wttWTT_Type) ' Set printer SCALING End Select .PrintArea = rPanelWholeTable.Address ' Set up print area. This places a dotted boundary line around the area. End With .DisplayPageBreaks = True ' Display Print Border. End With End Sub originalZoom.xls 110KViewDownload testZoom.xls 99KViewDownload -- -- 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
Fwd: Fw: $$Excel-Macros$$ Need a help in Combo and Check Boxes
Dear Surya, Please see attached sheet if it help to u.. -- Forwarded message -- From: suryaprasad...@gmail.com Date: Mon, Sep 5, 2011 at 11:15 PM Subject: Fw: $$Excel-Macros$$ Need a help in Combo and Check Boxes To: excel-macros@googlegroups.com **Hi all, Can anyone help me on this?? Regards Prasad Sent from BlackBerry® on Airtel -- *From: *Mr Excellent suryaprasad...@gmail.com *Date: *Mon, 5 Sep 2011 17:10:47 +0530 *To: *excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Need a help in Combo and Check Boxes Hi Noorain, This helped me a lot but there is a single case in the code, how to add many cases if the select any other country and opt for other check boxes, please refer to the attachment Please help Thanks Prasad. On Mon, Sep 5, 2011 at 8:34 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Surya, Please see attached sheet if it help.. On Mon, Sep 5, 2011 at 7:06 AM, Mr Excellent suryaprasad...@gmail.comwrote: Hi Group, Need a small help, i have a combo box in the form and when i click on particular name INDIA one of the list box which says Indian currency to be updated should be enabled and the other list box should be disabled and vice versa as well, please help. Thanks, Prasad. -- -- 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/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- 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/discussexcel -- -- 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/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- -- 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/discussexcel Currency(Updated).xlsm Description: Binary data
Re: Fw: $$Excel-Macros$$ Need a help in Combo and Check Boxes
Hi Noorain, Thank you for this , one doubt here can we Have a faded or shaded check box instead if hiding them? Thanks Prasad. On Tue, Sep 6, 2011 at 12:07 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Surya, Please see attached sheet if it help to u.. -- Forwarded message -- From: suryaprasad...@gmail.com Date: Mon, Sep 5, 2011 at 11:15 PM Subject: Fw: $$Excel-Macros$$ Need a help in Combo and Check Boxes To: excel-macros@googlegroups.com **Hi all, Can anyone help me on this?? Regards Prasad Sent from BlackBerry® on Airtel -- *From: *Mr Excellent suryaprasad...@gmail.com *Date: *Mon, 5 Sep 2011 17:10:47 +0530 *To: *excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Need a help in Combo and Check Boxes Hi Noorain, This helped me a lot but there is a single case in the code, how to add many cases if the select any other country and opt for other check boxes, please refer to the attachment Please help Thanks Prasad. On Mon, Sep 5, 2011 at 8:34 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Surya, Please see attached sheet if it help.. On Mon, Sep 5, 2011 at 7:06 AM, Mr Excellent suryaprasad...@gmail.comwrote: Hi Group, Need a small help, i have a combo box in the form and when i click on particular name INDIA one of the list box which says Indian currency to be updated should be enabled and the other list box should be disabled and vice versa as well, please help. Thanks, Prasad. -- -- 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/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- 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/discussexcel -- -- 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/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- 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/discussexcel -- -- 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/discussexcel
$$Excel-Macros$$ Calender needed in the check box
Hi team, I have a form where i have a check box where i need to update a date value in it, so what i need is a option of calender to enter the value of date in the given check box. Please help, as attached. Thanks Prasad. -- -- 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/discussexcel Calendar_required.xlsm Description: Binary data
Re: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003
CountIFS is a NEW function that does not work in earlier that xl2007. So you will need a combination of countif (no S) OR Sumproduct example =sumproduct((a2:a22=2)*(b222=”b”)) From: Amit Desai (MERU) Sent: Monday, September 05, 2011 1:52 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003 Dear All, Continuing from my below issue… my assistant have 2003 version of excel I have 2007. I need to pass on the task of preparing this MIS. But the same was prepared with countifs (2007 function). Need your help to formulate the file in excel 2003. I have attached the existing file in 2007 version (with formula) also saved the same file in 2003 version. Best Regards, Amit Desai From: Amit Desai (MERU) [mailto:amit.de...@merucabs.com] Sent: Friday, September 02, 2011 10:31 PM To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003 Not yet..could you please explain me in detail? Best Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Friday, September 02, 2011 6:07 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003 Have you tried looking at the help index for countifs? From: Amit Desai (MERU) Sent: Friday, September 02, 2011 4:51 AM To: excel-macros@googlegroups.com Subject: FW: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003 Dear Rajan, Thanks for this..but I do want to edit the attached formula, please explain the same how to do ? Also I want to have the formula with criteria of either or (in countifs we used to add 2 count ifs) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma Sent: Wednesday, August 31, 2011 11:04 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003 See the attached From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Venkat CV Sent: Wednesday, August 31, 2011 7:33 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003 Hi Amit See below link for Sumifs in 2003 http://chandoo.org/forums/topic/converting-sumifs-to-excel-2003 -- Best Regards, Venkat Chennai On Tue, Aug 30, 2011 at 9:54 PM, Amit Desai (MERU) amit.de...@merucabs.com wrote: Dear All, Do we have any option for countifs Sumifs formula in MS Excel 2003? Best Regards, Amit Desai Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- -- 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/discussexcel -- -- 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
Re: $$Excel-Macros$$ Calender needed in the check box
Dear Surya, Please see attached sheet... You can add Date Time Picker Box Step : *Tool Box-Right Click-additional Controls-Check Microsoft Date Time Picker Controls* -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Tue, Sep 6, 2011 at 12:34 AM, Mr Excellent suryaprasad...@gmail.comwrote: Hi team, I have a form where i have a check box where i need to update a date value in it, so what i need is a option of calender to enter the value of date in the given check box. Please help, as attached. Thanks Prasad. -- -- 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/discussexcel -- -- 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/discussexcel Calendar_required(Updated).xlsm Description: Binary data
Re: $$Excel-Macros$$ Doesn't this mean?
Thanks From: Daniel dcolarde...@free.fr To: excel-macros@googlegroups.com Sent: Monday, September 5, 2011 5:39 AM Subject: RE: $$Excel-Macros$$ Doesn't this mean? You have to write [C32] and [C33] (or Range(“C32”), Range(“C33”)). C32 is considered a variable name, not a range. HTH Daniel De :excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de David Lanne Envoyé : lundi 5 septembre 2011 07:06 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ Doesn't this mean? Sub OTX() ' ' OTX Macro ' ' If (c32 c33) Then End If If (c32 = c33) Then Range(g32:g33).Select Application.Run OT End If End Sub Doesn't this mean if c32 doesn't equal c33 nothing happens,if c32 equals c33 then it runs OT. Right now it runs OT whether c32/c33 are equal or not. Thanks, David Lanne -- -- 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/discussexcel-- -- 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/discussexcel -- -- 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/discussexcel
Re: $$Excel-Macros$$ Re: Doesn't this mean?
Thanks From: NOORAIN ANSARI noorain.ans...@gmail.com To: excel-macros@googlegroups.com Sent: Monday, September 5, 2011 3:00 AM Subject: Re: $$Excel-Macros$$ Re: Doesn't this mean? Dear David, Pls try it.. Sub Example() If Sheet1.Range(C32).Value = Sheet1.Range(C33).Value Then Sheet1.Range(g32:g33).Select Application.Run OT Else Exit Sub end if End Sub -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ On Mon, Sep 5, 2011 at 12:17 PM, lifescholar steve.ja...@lifescholar.net wrote: If (Range(c32) Range(c33)) Then On Sep 5, 6:06 am, David Lanne djl99_28...@yahoo.com wrote: Sub OTX() ' ' OTX Macro ' ' If (c32 c33) Then End If If (c32 = c33) Then Range(g32:g33).Select Application.Run OT End If End Sub Doesn't this mean if c32 doesn't equal c33 nothing happens,if c32 equals c33 then it runs OT. Right now it runs OT whether c32/c33 are equal or not. Thanks, David Lanne -- -- 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/discussexcel -- -- 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/discussexcel -- -- 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/discussexcel
Re: $$Excel-Macros$$ Re: Doesn't this mean?
Thanks From: lifescholar steve.ja...@lifescholar.net To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Monday, September 5, 2011 2:47 AM Subject: $$Excel-Macros$$ Re: Doesn't this mean? If (Range(c32) Range(c33)) Then On Sep 5, 6:06 am, David Lanne djl99_28...@yahoo.com wrote: Sub OTX() ' ' OTX Macro ' ' If (c32 c33) Then End If If (c32 = c33) Then Range(g32:g33).Select Application.Run OT End If End Sub Doesn't this mean if c32 doesn't equal c33 nothing happens,if c32 equals c33 then it runs OT. Right now it runs OT whether c32/c33 are equal or not. Thanks, David Lanne -- -- 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/discussexcel -- -- 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/discussexcel
Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - August'11
Congratulations Rajan Verma , Sunny, Noorain, Don Guillett, and Everyone... *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Mon, Sep 5, 2011 at 10:59 PM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Rajan Verma has been selected as 'Most Helpful Member' for the month of August'11 He has posted 152 posts in August 2011 and helped many people through his expertise. He has been consistent contributor to this excel forum and has acheived this recognition for second time consecutively. Thanks to Noorain, Venkat, Sunny(XLS S), Don Guillett, and other folks for helping excel enthusiasts voluntarily !! Keep it up !! Keep posting. Regards Ayush Jain Group Manager Microsoft MVP -- -- 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/discussexcel -- * * * * * * -- -- 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/discussexcel
Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - August'11
Congratulations BRO u rock :-) Sent from BlackBerry® on Airtel -Original Message- From: Venkat CV venkat1@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 6 Sep 2011 10:43:07 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - August'11 Congratulations Rajan Verma , Sunny, Noorain, Don Guillett, and Everyone... *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Mon, Sep 5, 2011 at 10:59 PM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Rajan Verma has been selected as 'Most Helpful Member' for the month of August'11 He has posted 152 posts in August 2011 and helped many people through his expertise. He has been consistent contributor to this excel forum and has acheived this recognition for second time consecutively. Thanks to Noorain, Venkat, Sunny(XLS S), Don Guillett, and other folks for helping excel enthusiasts voluntarily !! Keep it up !! Keep posting. Regards Ayush Jain Group Manager Microsoft MVP -- -- 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/discussexcel -- * * * * * * -- -- 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/discussexcel -- -- 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/discussexcel