Option Explicit goes above ALL code, not at the top of each sub.
It is only entered once.
Jim Cone




"Dan the Man"
wrote in message
So to be sure I have this correct (with respect to Option Explicit and
changing "cell" to "cells") is below the accurate adjustment to make with
respect to the 2 fucntion buttons on my Userform that are triggering the
Runtime 6028 Error? I will be very happy if this solves the problem and
allows the code to work!
__________________________________________________
Private Sub CommandButton3_Click()
Option Explicit
nrows = nrows + 1
mytable.Cells(nrows + 1, 1).Range.Text = TextBox1.Text
mytable.Cells(nrows + 1, 2) = Now()
incr = 1
nr = nrows
End Sub
__________________________________________________
Private Sub CommandButton4_Click()
Option Explicit
nrows = nr
mytable.Cells(nrows + 1, 1).Range.Text = TextBox1.Text
mytable.Cells(nrows + 1, 2) = Now()
End Sub
__________________________________________________ _____________________