Re: $$Excel-Macros$$ How to learn VBA or MACORS myself at home???

2014-07-15 Thread 'DELIN FRANCIS' via MS EXCEL AND VBA MACROS
Thank you all         Delin.F   On Tuesday, 15 July 2014 7:13 AM, XLS S 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'

Re: $$Excel-Macros$$ How to learn VBA or MACORS myself at home???

2014-07-14 Thread XLS S
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 wrote: > Dear All, > > Good day to you > > I am here with a small

Re: $$Excel-Macros$$ How to learn VBA or MACORS myself at home???

2014-07-14 Thread 'David Lanne' via MS EXCEL AND VBA MACROS
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

Re: $$Excel-Macros$$ How to learn vba

2011-10-22 Thread Mr excel
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

Re: $$Excel-Macros$$ How to learn vba

2011-10-22 Thread chhajersandeep
Thanks Dilip Regards, CA.Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Dilip Pandey Sender: excel-macros@googlegroups.com Date: Sat, 22 Oct 2011 22:33:56 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to learn vba Hi

Re: $$Excel-Macros$$ How to learn vba

2011-10-22 Thread Dilip Pandey
2:16:15 > To: > 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 > r

Re: $$Excel-Macros$$ How to learn vba

2011-10-22 Thread chhajersandeep
To: 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

Re: $$Excel-Macros$$ How to learn vba

2011-10-22 Thread Dilip Pandey
ds > CA Sandeep Kr Chhajer. > > Sent on my BlackBerry® from Vodafone > > -Original Message- > From: Dilip Pandey > Sender: excel-macros@googlegroups.com > Date: Fri, 21 Oct 2011 11:09:04 > To: > Reply-To: excel-macros@googlegroups.com > Subject: Re: $$Excel-

Re: $$Excel-Macros$$ How to learn vba

2011-10-21 Thread hanumant shinde
p you. > >From: "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 us

Re: $$Excel-Macros$$ How to learn vba

2011-10-21 Thread Jorge Marques
>> which type code. >> >> Thanks and regards >> CA Sandeep Kr Chhajer. >> >> Sent on my BlackBerry® from Vodafone >> >> -Original Message- >> From: Dilip Pandey >> Sender: excel-macros@googlegroups.com >> Date: Fri, 21 Oct 2011 11:

Re: $$Excel-Macros$$ How to learn vba

2011-10-20 Thread NOORAIN ANSARI
ndey > Sender: excel-macros@googlegroups.com > Date: Fri, 21 Oct 2011 11:09:04 > To: > Reply-To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ How to learn vba > > Hi, > > Below are the explanation of looping codes:- > > Loopin

Re: $$Excel-Macros$$ How to learn vba

2011-10-20 Thread chhajersandeep
:04 To: 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

Re: $$Excel-Macros$$ How to learn vba

2011-10-20 Thread Dilip Pandey
Hi, Below are the explanation of looping codes:- Looping codes Do While/ Until "conditon" Exit Do Loop ` Do - - Exit Do - - Loop While / Until "condition"

Re: $$Excel-Macros$$ How to learn vba

2011-10-20 Thread Mr excel
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) wrote: > Dear Mr excel, > > You are welcome to visit your brother here > http://www.mrexcel.com/articles.shtml#VBA > > best regards > ~

Re: $$Excel-Macros$$ How to learn vba

2011-10-20 Thread STDEV(i)
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 wrote: > Thanks all,for the replies.i had been working with the VBA macro > recorder.Its really very funny

Re: $$Excel-Macros$$ How to learn vba

2011-10-19 Thread Mr excel
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 s

Re: $$Excel-Macros$$ How to learn vba

2011-10-15 Thread Dilip Pandey
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.

Re: $$Excel-Macros$$ How to learn vba

2011-10-15 Thread XLS S
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=v

Re: $$Excel-Macros$$ How to learn vba

2011-10-15 Thread Venkat CV
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

RE: $$Excel-Macros$$ How to learn VBA Languages and Macros

2011-01-05 Thread Susan
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. Sha

Re: $$Excel-Macros$$ How to learn VBA Languages and Macros

2011-01-05 Thread B Sharma
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" wrote: > I useExcel2007 Visual Basic for Applications, Step by Step.  This b

RE: $$Excel-Macros$$ How to learn VBA Languages and Macros

2010-12-30 Thread Susan
I use Excel 2007 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