Results 1 to 3 of 3

How to use a String to reference to a CheckBox object?

Threaded View

excelnewbie80 How to use a String to... 06-15-2012, 03:04 AM
Md Aejaz Re: How to use a String to... 06-15-2012, 03:37 AM
Kyle123 Re: How to use a String to... 06-15-2012, 03:59 AM
  1. #1
    Registered User
    Join Date
    05-28-2012
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    19

    How to use a String to reference to a CheckBox object?

    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1