View Single Post
  #2 (permalink)  
Old September 23rd, 2005, 12:39 PM
echovue echovue is offline
Friend of Wrox
Join Date: Oct 2004
Location: Clinton, UT, USA.
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts

What you really want is a Control Array, but I don't think VBA supports that. Try this, I modified it from some code I found in the Excel VBA forum.

dim bx as object
for each bx in controls
   if left(,1)="t" then
   end if

Let me know if that works, if not, I know I have done this before, it's just a matter of finding out where!


Reply With Quote