+ Reply to Thread
Results 1 to 7 of 7

Loop examples needed to aid learning

  1. #1
    Registered User
    Join Date
    08-30-2010
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    30

    Loop examples needed to aid learning

    Hi

    I am currently trying to get my head around using Excel VBA, and have made good progress over the past year.

    However, I still struggle tremendously with Loops within Loops, whether they are For Each, Do Until, Do While etc...

    I have read various books, but still struggle.

    Does anyone now of, or have Examples, that are heavily commented, which I could use as an aid in learning.

    Many thanks

    Ronan

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Loop examples needed to aid learning

    It would be better to describe a scenario where you think such a loop may be needed
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Loop examples needed to aid learning

    from the forum "Excel Tips" top of page

    http://www.exceltip.com/show_tip/Usi...Excel/628.html
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  4. #4
    Registered User
    Join Date
    08-30-2010
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    30

    Re: Loop examples needed to aid learning

    Thanks I will give those site a visit...

    Ronan

  5. #5
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Loop examples needed to aid learning

    for those seeking similar there may well be addition links on ronanm's cross post:

    http://www.mrexcel.com/forum/showthread.php?t=528315

    @ronanm, given the nature of the question (resource gathering) this doesn't really constitute a breach of rules (cross posting) but it would still be nice to detail the cross posted link(s) for the benefit of others.

  6. #6
    Forum Contributor mccrimmon's Avatar
    Join Date
    02-19-2004
    Location
    Scotland
    MS-Off Ver
    2003
    Posts
    249

    Re: Loop examples needed to aid learning

    Quote Originally Posted by ronanm View Post
    Hi

    I am currently trying to get my head around using Excel VBA, and have made good progress over the past year.

    However, I still struggle tremendously with Loops within Loops, whether they are For Each, Do Until, Do While etc...

    I have read various books, but still struggle.

    Does anyone now of, or have Examples, that are heavily commented, which I could use as an aid in learning.

    Many thanks

    Ronan
    Being relatively new myself, I thought I would start contributing to help expand my knowledge.

    Some examples of Loops in code I have used are as follows:

    Please Login or Register  to view this content.

    Please Login or Register  to view this content.
    McCrimmon

  7. #7
    Valued Forum Contributor jwright650's Avatar
    Join Date
    12-10-2010
    Location
    Va, USA
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    606

    Re: Loop examples needed to aid learning

    Life is like a roll of toilet paper. The closer it gets to the end, the faster it goes.
    John Wright

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1