Thread: looping through controls
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Martin Martin is offline
external usenet poster
  
Posts: 336
Default looping through controls
I think you have to do it by specific type of control, eg TextBox

"cmpcwil2" wrote:


Is there a way to loop through controls (e.g. vb checkBox) that are on
the worksheet. I know you can do this for the userForm as follows

For Each ctrl In UserForm1.Controls
If TypeName(ctrl) = "CheckBox" Then
MsgBox CheckBox.Text
End If
Next ctrl

Is this possible for an active worksheet?


--
cmpcwil2
------------------------------------------------------------------------
cmpcwil2's Profile: http://www.excelforum.com/member.php...o&userid=33411
View this thread: http://www.excelforum.com/showthread...hreadid=532616


Reply With QuoteReply With Quote