Re: $$Excel-Macros$$ How to learn VBA or MACORS myself at home???
Thank you all Delin.F On Tuesday, 15 July 2014 7:13 AM, XLS S xlst...@gmail.com wrote: Dear Delin, Please try below link. http://www.excel-pratique.com/en/vba.php Its a very useful and simple . Enjoy Team XLS On Mon, Jul 14, 2014 at 10:56 PM, 'DELIN FRANCIS' via MS EXCEL AND VBA MACROS excel-macros@googlegroups.com wrote: Dear All, Good day to you I am here with a small request, is there any way to learn basics of VBA , since am not good in VBA or MACROS Is there any books available to learn VBA myself at home ?? like how to use it ?? or what is formulas or syntax using for a conditions ?? please help me i am really interested in learning, but i have no time to go for classes. please advise me what can i do.. thank you all in advance for helping me.. regards Delin F Delin.F -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ How to learn VBA or MACORS myself at home???
Dear All, Good day to you I am here with a small request, is there any way to learn basics of VBA , since am not good in VBA or MACROS Is there any books available to learn VBA myself at home ?? like how to use it ?? or what is formulas or syntax using for a conditions ?? please help me i am really interested in learning, but i have no time to go for classes. please advise me what can i do.. thank you all in advance for helping me.. regards Delin F Delin.F -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ How to learn VBA or MACORS myself at home???
Slaying Excel Dragons by Mike Girvin is a good book. I still can't figure out all the language stuff. But what helped me was recording marcos doing simple stuff, (ex renaming sheets, sorting data, etc) then stepping into the marco and I could see what its doing, which helped down the line when I did something similar. . On Monday, July 14, 2014 1:26 PM, 'DELIN FRANCIS' via MS EXCEL AND VBA MACROS excel-macros@googlegroups.com wrote: Dear All, Good day to you I am here with a small request, is there any way to learn basics of VBA , since am not good in VBA or MACROS Is there any books available to learn VBA myself at home ?? like how to use it ?? or what is formulas or syntax using for a conditions ?? please help me i am really interested in learning, but i have no time to go for classes. please advise me what can i do.. thank you all in advance for helping me.. regards Delin F Delin.F -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ How to learn VBA or MACORS myself at home???
Dear Delin, Please try below link. http://www.excel-pratique.com/en/vba.php Its a very useful and simple . Enjoy Team XLS On Mon, Jul 14, 2014 at 10:56 PM, 'DELIN FRANCIS' via MS EXCEL AND VBA MACROS excel-macros@googlegroups.com wrote: Dear All, Good day to you I am here with a small request, is there any way to learn basics of VBA , since am not good in VBA or MACROS Is there any books available to learn VBA myself at home ?? like how to use it ?? or what is formulas or syntax using for a conditions ?? please help me i am really interested in learning, but i have no time to go for classes. please advise me what can i do.. thank you all in advance for helping me.. regards Delin F *Delin.F* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ How to learn vba
Thanks for explaining this. Dear Sandeep, as some members suggested you should take the help of web search engines, as the Loop example I have shared is kind of ready reckoner which a experienced can refers for looping purpose. If you have any specific issue and not able to judge which type of loop to be used, then you are welcome to share the query via another post. Thanks Regards, DILIPandey On 10/21/11, chhajersand...@gmail.com chhajersand...@gmail.com wrote: Dear Dilip, It wud have been gr8 if u also explain the codes in brief..when to use which type code. Thanks and regards CA Sandeep Kr Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Dilip Pandey dilipan...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 21 Oct 2011 11:09:04 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to learn vba Hi, Below are the explanation of looping codes:- Looping codes Do While/ Until conditon Exit Do Loop ` Do - - Exit Do - - Loop While / Until condition '' While condition Wend If condition Then Else End if `` Case condition End Case `` For condition Next `` For Each condition Next ` With selection End with = Using FOR loop for each sheet in workbook == For i = 1 To Sheets.Count Sheets(i).Select 'your code here Next Regards, DILIPandey On 10/20/11, Mr excel excelkeec...@gmail.com wrote: Thanks all,for the replies.i had been working with the VBA macro recorder.Its really very funny intersting to learn like this.But there are some situation where i need to learn the programming techniques like Do Loops,While Loops etc which cannot be learnt from macro recording.Please suggest me some ideas or techniques for learning...Thanks in advance to all those who had helped 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 -- Thanks Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- 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, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2
Re: $$Excel-Macros$$ How to learn vba
Thanks Dilip, I wud try to find it in web server...I jus want to know any site to start with as a beginner... With Thanks CA Sandeep Chhajer Sent on my BlackBerry® from Vodafone -Original Message- From: Dilip Pandey dilipan...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 22 Oct 2011 22:16:15 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to learn vba Thanks for explaining this. Dear Sandeep, as some members suggested you should take the help of web search engines, as the Loop example I have shared is kind of ready reckoner which a experienced can refers for looping purpose. If you have any specific issue and not able to judge which type of loop to be used, then you are welcome to share the query via another post. Thanks Regards, DILIPandey On 10/21/11, chhajersand...@gmail.com chhajersand...@gmail.com wrote: Dear Dilip, It wud have been gr8 if u also explain the codes in brief..when to use which type code. Thanks and regards CA Sandeep Kr Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Dilip Pandey dilipan...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 21 Oct 2011 11:09:04 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to learn vba Hi, Below are the explanation of looping codes:- Looping codes Do While/ Until conditon Exit Do Loop ` Do - - Exit Do - - Loop While / Until condition '' While condition Wend If condition Then Else End if `` Case condition End Case `` For condition Next `` For Each condition Next ` With selection End with = Using FOR loop for each sheet in workbook == For i = 1 To Sheets.Count Sheets(i).Select 'your code here Next Regards, DILIPandey On 10/20/11, Mr excel excelkeec...@gmail.com wrote: Thanks all,for the replies.i had been working with the VBA macro recorder.Its really very funny intersting to learn like this.But there are some situation where i need to learn the programming techniques like Do Loops,While Loops etc which cannot be learnt from macro recording.Please suggest me some ideas or techniques for learning...Thanks in advance to all those who had helped 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 -- Thanks Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- 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
Re: $$Excel-Macros$$ How to learn vba
Hi Sandeep, You can try below site:- http://www.ozgrid.com/VBA/loops.htm You can also search for other web portals as I know that there are many. Best of Luck. Thanks, DILIPandey On 10/22/11, chhajersand...@gmail.com chhajersand...@gmail.com wrote: Thanks Dilip, I wud try to find it in web server...I jus want to know any site to start with as a beginner... With Thanks CA Sandeep Chhajer Sent on my BlackBerry® from Vodafone -Original Message- From: Dilip Pandey dilipan...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 22 Oct 2011 22:16:15 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to learn vba Thanks for explaining this. Dear Sandeep, as some members suggested you should take the help of web search engines, as the Loop example I have shared is kind of ready reckoner which a experienced can refers for looping purpose. If you have any specific issue and not able to judge which type of loop to be used, then you are welcome to share the query via another post. Thanks Regards, DILIPandey On 10/21/11, chhajersand...@gmail.com chhajersand...@gmail.com wrote: Dear Dilip, It wud have been gr8 if u also explain the codes in brief..when to use which type code. Thanks and regards CA Sandeep Kr Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Dilip Pandey dilipan...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 21 Oct 2011 11:09:04 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to learn vba Hi, Below are the explanation of looping codes:- Looping codes Do While/ Until conditon Exit Do Loop ` Do - - Exit Do - - Loop While / Until condition '' While condition Wend If condition Then Else End if `` Case condition End Case `` For condition Next `` For Each condition Next ` With selection End with = Using FOR loop for each sheet in workbook == For i = 1 To Sheets.Count Sheets(i).Select 'your code here Next Regards, DILIPandey On 10/20/11, Mr excel excelkeec...@gmail.com wrote: Thanks all,for the replies.i had been working with the VBA macro recorder.Its really very funny intersting to learn like this.But there are some situation where i need to learn the programming techniques like Do Loops,While Loops etc which cannot be learnt from macro recording.Please suggest me some ideas or techniques for learning...Thanks in advance to all those who had helped 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 -- Thanks Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- 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
Re: $$Excel-Macros$$ How to learn vba
Thanks Dilip Regards, CA.Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Dilip Pandey dilipan...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 22 Oct 2011 22:33:56 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to learn vba Hi Sandeep, You can try below site:- http://www.ozgrid.com/VBA/loops.htm You can also search for other web portals as I know that there are many. Best of Luck. Thanks, DILIPandey On 10/22/11, chhajersand...@gmail.com chhajersand...@gmail.com wrote: Thanks Dilip, I wud try to find it in web server...I jus want to know any site to start with as a beginner... With Thanks CA Sandeep Chhajer Sent on my BlackBerry® from Vodafone -Original Message- From: Dilip Pandey dilipan...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 22 Oct 2011 22:16:15 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to learn vba Thanks for explaining this. Dear Sandeep, as some members suggested you should take the help of web search engines, as the Loop example I have shared is kind of ready reckoner which a experienced can refers for looping purpose. If you have any specific issue and not able to judge which type of loop to be used, then you are welcome to share the query via another post. Thanks Regards, DILIPandey On 10/21/11, chhajersand...@gmail.com chhajersand...@gmail.com wrote: Dear Dilip, It wud have been gr8 if u also explain the codes in brief..when to use which type code. Thanks and regards CA Sandeep Kr Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Dilip Pandey dilipan...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 21 Oct 2011 11:09:04 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to learn vba Hi, Below are the explanation of looping codes:- Looping codes Do While/ Until conditon Exit Do Loop ` Do - - Exit Do - - Loop While / Until condition '' While condition Wend If condition Then Else End if `` Case condition End Case `` For condition Next `` For Each condition Next ` With selection End with = Using FOR loop for each sheet in workbook == For i = 1 To Sheets.Count Sheets(i).Select 'your code here Next Regards, DILIPandey On 10/20/11, Mr excel excelkeec...@gmail.com wrote: Thanks all,for the replies.i had been working with the VBA macro recorder.Its really very funny intersting to learn like this.But there are some situation where i need to learn the programming techniques like Do Loops,While Loops etc which cannot be learnt from macro recording.Please suggest me some ideas or techniques for learning...Thanks in advance to all those who had helped 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 -- Thanks Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- 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
Re: $$Excel-Macros$$ How to learn vba
Hi all and a ton thanks for updating this mail frequently.I had been struggling with the Do Loops from many days.i m following whatever the links had been given re reading studying the examples.I feel a little bit confident with the loops now.thanks for the great support and i request you all to pls keep this mail live by posting more more examples. Thanking you. -- -- 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$$ How to learn vba
Dear sandeep/Mr. excel, Please find attached Sheet with Example. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Fri, Oct 21, 2011 at 11:13 AM, chhajersand...@gmail.com wrote: Dear Dilip, It wud have been gr8 if u also explain the codes in brief..when to use which type code. Thanks and regards CA Sandeep Kr Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Dilip Pandey dilipan...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 21 Oct 2011 11:09:04 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to learn vba Hi, Below are the explanation of looping codes:- Looping codes Do While/ Until conditon Exit Do Loop ` Do - - Exit Do - - Loop While / Until condition '' While condition Wend If condition Then Else End if `` Case condition End Case `` For condition Next `` For Each condition Next ` With selection End with = Using FOR loop for each sheet in workbook == For i = 1 To Sheets.Count Sheets(i).Select 'your code here Next Regards, DILIPandey On 10/20/11, Mr excel excelkeec...@gmail.com wrote: Thanks all,for the replies.i had been working with the VBA macro recorder.Its really very funny intersting to learn like this.But there are some situation where i need to learn the programming techniques like Do Loops,While Loops etc which cannot be learnt from macro recording.Please suggest me some ideas or techniques for learning...Thanks in advance to all those who had helped 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 -- Thanks Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- 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
Re: $$Excel-Macros$$ How to learn vba
Hi friend, I use a lot this simple example of a loop until with an inputbox. 2011/10/21 NOORAIN ANSARI noorain.ans...@gmail.com Dear sandeep/Mr. excel, Please find attached Sheet with Example. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Fri, Oct 21, 2011 at 11:13 AM, chhajersand...@gmail.com wrote: Dear Dilip, It wud have been gr8 if u also explain the codes in brief..when to use which type code. Thanks and regards CA Sandeep Kr Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Dilip Pandey dilipan...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 21 Oct 2011 11:09:04 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to learn vba Hi, Below are the explanation of looping codes:- Looping codes Do While/ Until conditon Exit Do Loop ` Do - - Exit Do - - Loop While / Until condition '' While condition Wend If condition Then Else End if `` Case condition End Case `` For condition Next `` For Each condition Next ` With selection End with = Using FOR loop for each sheet in workbook == For i = 1 To Sheets.Count Sheets(i).Select 'your code here Next Regards, DILIPandey On 10/20/11, Mr excel excelkeec...@gmail.com wrote: Thanks all,for the replies.i had been working with the VBA macro recorder.Its really very funny intersting to learn like this.But there are some situation where i need to learn the programming techniques like Do Loops,While Loops etc which cannot be learnt from macro recording.Please suggest me some ideas or techniques for learning...Thanks in advance to all those who had helped 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 -- Thanks Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- 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
Re: $$Excel-Macros$$ How to learn vba
i think it will be better if you google all this information given by Dilip as explaining everythign in detail is not possible so if u google all this you will have better idea. 1. While, do while and do until are same hardly any difference. 2. for and for each is also same but for is used when you know how many iterations you want. whereas for each normally used with objects like sheets,range,workbook etc For i = 1 To Sheets.Count Sheets(i).Select 'your code here Next same example can be used for for each loop. dim sht as sheet for each sht in worksheets sht.select next 3. For is used when you know how many iterations you want lets say 1 to 10. while, do while do until loops are used when you dont know number of iterations you want. 4. select case and if else is same in functionality only difference in syntax. dont know how much it will help you. From: chhajersand...@gmail.com chhajersand...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, 21 October 2011 11:13 AM Subject: Re: $$Excel-Macros$$ How to learn vba Dear Dilip, It wud have been gr8 if u also explain the codes in brief..when to use which type code. Thanks and regards CA Sandeep Kr Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Dilip Pandey dilipan...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 21 Oct 2011 11:09:04 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to learn vba Hi, Below are the explanation of looping codes:- Looping codes Do While/ Until conditon Exit Do Loop ` Do - - Exit Do - - Loop While / Until condition '' While condition Wend If condition Then Else End if `` Case condition End Case `` For condition Next `` For Each condition Next ` With selection End with = Using FOR loop for each sheet in workbook == For i = 1 To Sheets.Count Sheets(i).Select 'your code here Next Regards, DILIPandey On 10/20/11, Mr excel excelkeec...@gmail.com wrote: Thanks all,for the replies.i had been working with the VBA macro recorder.Its really very funny intersting to learn like this.But there are some situation where i need to learn the programming techniques like Do Loops,While Loops etc which cannot be learnt from macro recording.Please suggest me some ideas or techniques for learning...Thanks in advance to all those who had helped 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 -- Thanks Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- 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
Re: $$Excel-Macros$$ How to learn vba
Dear Mr excel, You are welcome to visit your brother here http://www.mrexcel.com/articles.shtml#VBA best regards ~siti your fans from indonesia On Thu, Oct 20, 2011 at 8:21 AM, Mr excel excelkeec...@gmail.com wrote: Thanks all,for the replies.i had been working with the VBA macro recorder.Its really very funny intersting to learn like this.But there are some situation where i need to learn the programming techniques like Do Loops,While Loops etc which cannot be learnt from macro recording.Please suggest me some ideas or techniques for learning...Thanks in advance to all those who had helped 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
Re: $$Excel-Macros$$ How to learn vba
thanks setiyowati.for that link.Pls do update this mail when ever anybody comes across new linksThanks in advance. On Fri, Oct 21, 2011 at 4:36 AM, STDEV(i) setiyowati.d...@gmail.com wrote: Dear Mr excel, You are welcome to visit your brother here http://www.mrexcel.com/articles.shtml#VBA best regards ~siti your fans from indonesia On Thu, Oct 20, 2011 at 8:21 AM, Mr excel excelkeec...@gmail.com wrote: Thanks all,for the replies.i had been working with the VBA macro recorder.Its really very funny intersting to learn like this.But there are some situation where i need to learn the programming techniques like Do Loops,While Loops etc which cannot be learnt from macro recording.Please suggest me some ideas or techniques for learning...Thanks in advance to all those who had helped 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 -- -- 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$$ How to learn vba
Hi, Below are the explanation of looping codes:- Looping codes Do While/ Until conditon Exit Do Loop ` Do - - Exit Do - - Loop While / Until condition '' While condition Wend If condition Then Else End if `` Case condition End Case `` For condition Next `` For Each condition Next ` With selection End with = Using FOR loop for each sheet in workbook == For i = 1 To Sheets.Count Sheets(i).Select 'your code here Next Regards, DILIPandey On 10/20/11, Mr excel excelkeec...@gmail.com wrote: Thanks all,for the replies.i had been working with the VBA macro recorder.Its really very funny intersting to learn like this.But there are some situation where i need to learn the programming techniques like Do Loops,While Loops etc which cannot be learnt from macro recording.Please suggest me some ideas or techniques for learning...Thanks in advance to all those who had helped 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 -- Thanks Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- 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$$ How to learn vba
Dear Dilip, It wud have been gr8 if u also explain the codes in brief..when to use which type code. Thanks and regards CA Sandeep Kr Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Dilip Pandey dilipan...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 21 Oct 2011 11:09:04 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to learn vba Hi, Below are the explanation of looping codes:- Looping codes Do While/ Until conditon Exit Do Loop ` Do - - Exit Do - - Loop While / Until condition '' While condition Wend If condition Then Else End if `` Case condition End Case `` For condition Next `` For Each condition Next ` With selection End with = Using FOR loop for each sheet in workbook == For i = 1 To Sheets.Count Sheets(i).Select 'your code here Next Regards, DILIPandey On 10/20/11, Mr excel excelkeec...@gmail.com wrote: Thanks all,for the replies.i had been working with the VBA macro recorder.Its really very funny intersting to learn like this.But there are some situation where i need to learn the programming techniques like Do Loops,While Loops etc which cannot be learnt from macro recording.Please suggest me some ideas or techniques for learning...Thanks in advance to all those who had helped 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 -- Thanks Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- 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$$ How to learn vba
Thanks all,for the replies.i had been working with the VBA macro recorder.Its really very funny intersting to learn like this.But there are some situation where i need to learn the programming techniques like Do Loops,While Loops etc which cannot be learnt from macro recording.Please suggest me some ideas or techniques for learning...Thanks in advance to all those who had helped 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$$ How to learn vba
Hi group, i would like to know a specific method for learning Excel vba.I mean i m just getting perplexed worried about how to learn excel vba on seeing this so many examples in this forum.I could not get a right point where to start in vba. Kindly suggest some tips or methods so that i can follow in learning excel vba. Thanks in advance. -- -- 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$$ How to learn vba
Hi, Refer Below Links.. http://www.cpearson.com/Excel/MainPage.aspx http://www.teachexcel.com/ http://www.ozgrid.com/VBA/ http://www.exceltip.com/st/Writing_Your_First_VBA_Function_in_Excel/631.html *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Sun, Oct 16, 2011 at 5:53 AM, Mr excel excelkeec...@gmail.com wrote: Hi group, i would like to know a specific method for learning Excel vba.I mean i m just getting perplexed worried about how to learn excel vba on seeing this so many examples in this forum.I could not get a right point where to start in vba. Kindly suggest some tips or methods so that i can follow in learning excel vba. Thanks in advance. -- -- 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$$ How to learn vba
firstly learn recording then play with recorded code http://www.youtube.com/watch?v=Ycab4OiPug0 http://www.internet4classrooms.com/excel_record_macro.htm http://office.microsoft.com/en-us/excel-help/record-and-use-excel-macros-HA001054837.aspx http://msdn.microsoft.com/en-us/library/7kyhdt1z%28v=vs.80%29.aspx On Sun, Oct 16, 2011 at 5:53 AM, Mr excel excelkeec...@gmail.com wrote: Hi group, i would like to know a specific method for learning Excel vba.I mean i m just getting perplexed worried about how to learn excel vba on seeing this so many examples in this forum.I could not get a right point where to start in vba. Kindly suggest some tips or methods so that i can follow in learning excel vba. Thanks in advance. -- -- 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$$ How to learn vba
Hi Mr. Excel, I would suggest you to enable recording and do whatever you want to do in Excel window. Now go to code window (Alt + F11) and see how Excel transformed your actions into vba code and try to understand that. Change some references there and play that again to see your edited actions. Keep doing like this and you will learn automatically plus you can refer the links as well as mentioned by group members.. Best of luck. Regards, DILIPandey On 10/16/11, Mr excel excelkeec...@gmail.com wrote: Hi group, i would like to know a specific method for learning Excel vba.I mean i m just getting perplexed worried about how to learn excel vba on seeing this so many examples in this forum.I could not get a right point where to start in vba. Kindly suggest some tips or methods so that i can follow in learning excel vba. Thanks in advance. -- -- 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, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- 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$$ How to learn VBA Languages and Macros
Hey Susan,, If you have that book then please send it to my email address or attach here... my email address issharma(dot)ctc(at the rate)gmail(dot)com Thanks Regards, B. Sharma On Dec 30 2010, 9:43 pm, Susan susan.m.ander...@comcast.net wrote: I useExcel2007 Visual Basic for Applications, Step by Step. This book was extremely helpful to me as I am a new in learning VB and wanted to write more extensive macros. Susan -Original Message- From:excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of B Sharma Sent: Thursday, December 30, 2010 3:13 AM To: MSEXCELANDVBAMACROS Subject: $$Excel-Macros$$ How to learnVBALanguages and Macros Dear Friends, Firstly I want to thank you all for making and using this wonderful educational site. Its really superb. I am somewhat good inexcelinbuilt formulas functions and able to complete most of my work through that. But I need your help as I want to learnVBAprogramming Macros and want to automate my working. Please suggest me the way, I want to know how to write programs starting with some small programs in a easy language along with the meaning /definition of objects, array, classes, etc. How to write programmes. Along with this I will appreciate if peoples send me their working files, learning books, etc. through which I can learn programmes, etc. -- --- - -- Some important links forexcelusers: 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.Exceltutorials athttp://www.excel-macros.blogspot.com 4. LearnVBAMacros athttp://www.quickvba.blogspot.com 5.ExcelTips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email toexcel-mac...@googlegroups.com Like our page on facebook , Just follow below linkhttp://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall;... -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
RE: $$Excel-Macros$$ How to learn VBA Languages and Macros
Hi, I paid for the book via Amazon.com... you could check out your local library perhaps they have it to check out for 'free'. Susan -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of B Sharma Sent: Wednesday, January 05, 2011 3:30 AM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ How to learn VBA Languages and Macros Hey Susan,, If you have that book then please send it to my email address or attach here... my email address issharma(dot)ctc(at the rate)gmail(dot)com Thanks Regards, B. Sharma On Dec 30 2010, 9:43 pm, Susan susan.m.ander...@comcast.net wrote: I useExcel2007 Visual Basic for Applications, Step by Step. This book was extremely helpful to me as I am a new in learning VB and wanted to write more extensive macros. Susan -Original Message- From:excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of B Sharma Sent: Thursday, December 30, 2010 3:13 AM To: MSEXCELANDVBAMACROS Subject: $$Excel-Macros$$ How to learnVBALanguages and Macros Dear Friends, Firstly I want to thank you all for making and using this wonderful educational site. Its really superb. I am somewhat good inexcelinbuilt formulas functions and able to complete most of my work through that. But I need your help as I want to learnVBAprogramming Macros and want to automate my working. Please suggest me the way, I want to know how to write programs starting with some small programs in a easy language along with the meaning /definition of objects, array, classes, etc. How to write programmes. Along with this I will appreciate if peoples send me their working files, learning books, etc. through which I can learn programmes, etc. -- --- - -- Some important links forexcelusers: 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.Exceltutorials athttp://www.excel-macros.blogspot.com 4. LearnVBAMacros athttp://www.quickvba.blogspot.com 5.ExcelTips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email toexcel-mac...@googlegroups.com Like our page on facebook , Just follow below linkhttp://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall;... -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ How to learn VBA Languages and Macros
Dear Friends, Firstly I want to thank you all for making and using this wonderful educational site. Its really superb. I am somewhat good in excel inbuilt formulas functions and able to complete most of my work through that. But I need your help as I want to learn VBA programming Macros and want to automate my working. Please suggest me the way, I want to know how to write programs starting with some small programs in a easy language along with the meaning /definition of objects, array, classes, etc. How to write programmes. Along with this I will appreciate if peoples send me their working files, learning books, etc. through which I can learn programmes, etc. -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts