Private Sub CommandButton1_Click() 
    Static rw As Long 
    rw = rw + 1 
    if isempty(range("a" & rw) then
        msgbox "no record in row " & rw
    else
       textbox1 = Range("a" & rw) 
    end if
End Sub
what's the difference between the two?
dim is reinitialised each time a procedure is called, whereas static retains it value between calls