+ Reply to Thread
Results 1 to 2 of 2

Cycle Through Table Data Using a Command Button

  1. #1
    Registered User
    Join Date
    06-28-2012
    Location
    Columbus, OH
    MS-Off Ver
    Excel 2010
    Posts
    5

    Cycle Through Table Data Using a Command Button

    I'm pretty new to VBA so i'm going to forego trying to explain how i'm trying to solve the problem and instead just tell you what i'm trying to accomplish:

    I have a list of Data in two columns and a variable amount of rows (1,000 max). I want to click a command button and populate 2 cell based on the data in the list. When I click the command button again, i'd like to do the same thing but move down a row.

    So for example, say this is my original list:

    a 1
    b 2
    c 3

    I'd like to click a button and write "a" in cell A1 and "1" in cell B1. When I click the button again, I'd like to write "b" in cell A1 and "2" in cell B1.

    I'm sure there is an easy solultion, but i've been trying to pause loops until button click and it's been giving me all kinds of issues.

    Thanks!,
    Mark

    (Excel 2010)

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Cycle Through Table Data Using a Command Button

    Please Login or Register  to view this content.
    If solved remember to mark Thread as solved

+ 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