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

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/