View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Xtender Xtender is offline
external usenet poster
 
Posts: 1
Default Refer checkbox by name in a loop


Hello! I'm using a loop with counter, wich increases by one each time
The idea is to go through many checkboxes, check their value an
perform certain actions if it's "TRUE". However, I fail to refer t
checkboxes:

Code
-------------------
MyObject = Trim("CheckBox") & Trim(Str(Counter))
MyValue = MyObject.Value(
-------------------

As MyObject is a String, exel says : Runtime error '424' Objec
required.
How can I go through these checkboxes in a loop?
Many thanks

--
Xtende
-----------------------------------------------------------------------
Xtender's Profile: http://www.excelforum.com/member.php...fo&userid=3669
View this thread: http://www.excelforum.com/showthread.php?threadid=56423