| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to use vba to refer that if a checkbox is checked.. the contents beside it will be copied to another range - to add to excel form | Excel Programming | |||
| refer to a formula for use in a loop | Excel Programming | |||
| Loop through checkBox on worksheet | Excel Programming | |||
| For loop for Checkbox | Excel Programming | |||
| For loop for Checkbox | Excel Programming | |||
Threaded Mode
