I need to dynamically create a sub for CB's 1 to ??. I have a sub to create the boxes, I want to make a click sub for each box to call a handler with reference to the cell position the check box is in.
I know I have read a similar solution, but after searching for longer than is practical, I'll ask what's the magic words to create a sub.
Thanks in advance.
Please Login or Register to view this content.
Do a web search for something like Excel VBA Extensibility to find links to programmatically add code.
Here's one good reference Programming The VBA Editor
Alternatively, if you create Forms-type checkboxes instead of ActiveX-type checkboxes, you could assign one procedure to all the checkboxes. The procedure could use the Application.Caller method to determine which checkbox called the procedure and from there determine the cell range...etc.
Please Login or Register to view this content.Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks