Q:

Be able to select next cell down every time button is clicked Excel VBA

Below is the code that I have so far I am able to click the button and every time the button is clicked the cell selection is moved down the row by 1.
What I need is to start the selection on F3 and select down until about F35 but when I range it doesn't select the cells one by one.
Here is my code:
Dim rng As Range
Dim row As Range
Dim cell As Range

    Set rng = Range("F2")
    rng.Select
    For Each row In rng.Rows
        For Each cell In row.Cells
        ActiveCell.Offset(1, 0).Select
        Next cell
        Range("G66") = ActiveCell
    Next row

A:

if you have a Form button called Button1 then attach it a sub called Button1_Click() (or whatever, but be consistent with the name of the attached Sub)  and place the following code in any module:
Option Explicit

Dim notFirst As Boolean
Dim rng As Range

Sub Button1_Click()
    If notFirst Then
        If rng.row = 35 Then
            MsgBox "Sorry: you've already reached last valid cell in column F"
            Exit Sub
        Else
            Set rng = rng.Offset(1)
        End If
    Else
        Set rng = Range("F3")
        notFirst = True
    End If

    Range("G66").Value = rng.Value
End Sub

if you have a ActiveX button called Button1 then write the same code as above in its sheet code pane

