Hi,
I have created ActiveX checkboxes named chkbx1 and chkbx2. I am running a loop and I need to refer to these objects. I am not sure what is wrong with my code:
for i=1 to 2
if "chkbx" & i & .Object.Value = True then
'Do something
End If
next i
Hi,
I have created ActiveX checkboxes named chkbx1 and chkbx2. I am running a loop and I need to refer to these objects. I am not sure what is wrong with my code:
for i=1 to 2
if "chkbx" & i & .Object.Value = True then
'Do something
End If
next i
Last edited by excelnewbie80; 06-18-2012 at 03:57 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks