+ Reply to Thread
Results 1 to 3 of 3

Continuing a data input Macro down (the next 3 rows)

  1. #1
    Registered User
    Join Date
    11-02-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    17

    Continuing a data input Macro down (the next 3 rows)

    I have a data input macro, that requests date first.

    Then for data input 3 rows across.
    This all works well

    I am now trying to get the macro to continue to run the data input boxes for the rest of the very small 3x3 table.

    traceyjFlowerSumm test loop macro1.xlsm

  2. #2
    Valued Forum Contributor Sadath31's Avatar
    Join Date
    03-02-2011
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Office 365
    Posts
    452

    Re: Continuing a data input Macro down (the next 3 rows)

    code should be
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    11-02-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: Continuing a data input Macro down (the next 3 rows)

    This issue is solved, I'm just asking for a quick explanation on how - I hope I'm not breaking the forum rules by not marking it as solved - yet.


    Morning (for me) Sadath ....


    Your solution works like a charm, and I am very keen to understand how .....

    I compared the two VB (is that what its called ?)

    It was easy to see the difference and it is so minimal ....

    Is it simple to explain - For x = 1 to 3

    I tested it around and can have it doing longer or shorter by changing the 2nd number.

    I would just appreciate to know the meaning/rule of - For x = (I guess)




    Old
    Please Login or Register  to view this content.
    New
    Please Login or Register  to view this content.
    Last edited by pix; 11-10-2012 at 06:35 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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