+ Reply to Thread
Results 1 to 2 of 2

Detect change in programmatically created checkboxes

  1. #1
    Registered User
    Join Date
    04-12-2005
    Posts
    7

    Detect change in programmatically created checkboxes

    I have created a 40 x 5 array of checkboxes called GridChkBoxes in UserForm_Initalize(). I need be able to detect when they are changed, just like Private Sub CheckBox1_Change() if I had used the toolbox to add them.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello TomJones322,

    You will have to write code to automate the code writing for the CheckBoxes you have added or do manually. Either way is a lot of work. Automating the process through the program will require you add a reference to project to use VBE (Visual Basic Extensibility) which will allow you to modify the VBA Project code. Chip Pearson has an excellent tutorial on using and programming with VBE.

    Here is the web site: http://www.cpearson.com/excel/vbe.html

    Hope this helps,
    Leith Ross

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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