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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refer checkbox by name in a loop
Here is the answer from another forum: http://www.ozgrid.com/forum/showthre...d=1#post278392 -- Xtender ------------------------------------------------------------------------ Xtender's Profile: http://www.excelforum.com/member.php...o&userid=36693 View this thread: http://www.excelforum.com/showthread...hreadid=564233 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refer checkbox by name in a loop
There is rarely a need to post in multiple places, we either visit others,
or someone will give you an answer. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Xtender" wrote in message ... Here is the answer from another forum: http://www.ozgrid.com/forum/showthre...d=1#post278392 -- Xtender ------------------------------------------------------------------------ Xtender's Profile: http://www.excelforum.com/member.php...o&userid=36693 View this thread: http://www.excelforum.com/showthread...hreadid=564233 |
Reply |
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 |