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)