Well yes, my code assumed that it was some value in the worksheet itself that determines if a second and subsequent objective is defined. If it is something in the userform then you might use something like:
For lngIndex = 2 to 10
If Me.Controls("Objective" & lngIndex).Value <> vbNullString then
End if
Next lngIndex
|