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.
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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks