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

[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 *



On Sun, Oct 16, 2011 at 5:53 AM, Mr excel  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

[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=vs.80%29.aspx

On Sun, Oct 16, 2011 at 5:53 AM, Mr excel  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

[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.  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  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

[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 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

[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 & 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

[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
> ~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 & 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

[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"

''


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  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

[chhajersandeep]

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 
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:-

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  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

[NOORAIN ANSARI]

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,  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 
> 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:-
>
> 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  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
>
> <><><><><><><>&l

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

[Jorge Marques]

Hi friend, I use a lot this simple example of a loop until with an inputbox.

2011/10/21 NOORAIN ANSARI 

> 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,  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 
>> 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:-
>>
>> 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  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

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

[hanumant shinde]

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" 
>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 
>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:-
>
>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  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,

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

[Dilip Pandey]

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  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 
> 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:-
>
> 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  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, 

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

[chhajersandeep]

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 
Sender: excel-macros@googlegroups.com
Date: Sat, 22 Oct 2011 22: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
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  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 
> 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:-
>
> 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  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 f

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

[Dilip Pandey]

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  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 
> Sender: excel-macros@googlegroups.com
> Date: Sat, 22 Oct 2011 22: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
> 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  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 
>> 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:-
>>
>> 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  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
&

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

[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 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  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 
> Sender: excel-macros@googlegroups.com
> Date: Sat, 22 Oct 2011 22: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
> 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  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 
>> 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:-
>>
>> 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  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 li

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

[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 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 Languages and Macros

[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 Sharma
Sent: Thursday, December 30, 2010 3:13 AM
To: MS EXCEL AND VBA MACROS
Subject: $$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=wall&ref=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=wall&ref=ts

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

[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 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=wall&ref=ts

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

[Susan]

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"  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=wall&ref=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=wall&ref=ts

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

['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 did something 
similar. .  


On Monday, July 14, 2014 1:26 PM, 'DELIN FRANCIS' via MS EXCEL AND VBA MACROS 
 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???

[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 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???

['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' via MS EXCEL AND VBA MACROS 
 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.