| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
For...Each loop problem
For Each obj In ActiveSheet.OLEObjects
If obj.progID = "Forms.ListBox.1" Then 'enter your code here End If Next obj "synapse5150" wrote: I am trying to loop through all the listboxes I have in an Excel worksheet (NOT userform), and I'm having problems. If this was a userform, I would use a for each loop (like 'for each control in userform.controls') but I'm not sure how to translate this collection to a worksheet. Any ideas? -- synapse5150 ------------------------------------------------------------------------ synapse5150's Profile: http://www.thecodecage.com/forumz/member.php?userid=115 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=58770 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loop Within a Loop Problem | Excel Programming | |||
| Problem with Do While loop | Excel Programming | |||
| Loop Problem | Excel Programming | |||
| Loop Problem | Excel Programming | |||
| Problem adding charts using Do-Loop Until loop | Excel Programming | |||
Hybrid Mode
