calling text boxes/frames in procedures

[VBAmalta89]

i hve a text box within a frame which i would like to call in a procedure.

How do i reference it?

Also, what if the text box name was variable, i.e. they're called text1 to text8 and i need to call them in a loop?

 

[Damon Ostrander]

Hi VBAmalta89,

I'm not sure whether you are referring to a TextFrame object of a Shape object or a Frame control that groups controls on a userform. Can you clarify?

Damon

 

[VBAmalta89]

thanks for your reply but I have managed to solve the problem using teh code below:

Private Sub done_Click()

Dim i As Long

For i = 1 To 8 Step 1
  If Me.Controls("Frame" & i).Object.Enabled = True Then
    If Len(Me.Controls("AZone" & i).Value) = 0 Then
       MsgBox "Please enter AZone" & i & " value to proceed!"
       Exit Sub
    End If
  End If
Next i

MsgBox "Success!"

End Sub