View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\)[_1338_] Rick Rothstein \(MVP - VB\)[_1338_] is offline
external usenet poster
 
Posts: 1
Default How to access all the textboxes inside a frame?

This code will find each of them for you...

Dim C As Control
For Each C In Me.Controls
If C.Parent.Name = "Frame1" Then
If TypeName(C) = "TextBox" Then
'
' You found a TextBox inside Frame1
' Put your code for it here.
'
End If
End If
Next

Rick


"Yajiv" wrote in message
...
I have some 10 text boxes inside a frame. how can i iterate through
them?