Add codes for dynamically created Active x-check boxes using vba

Please Login or Register  to view this content.

This Code will help me to create many active-x check boxes as per my requirement, I need to know how to add codes to these check boxes.every check boxes will have similar codes.
for example, a row will be mapped to these check boxes respectively. these check boxes will be checked and a command button will be clicked, which will copy the rows of selected check boxes to another sheet.
if possible i can create separate names for each check box while creating it nd add codes accordingly.
Is there any way?

Hi sujin and welcome to ExcelForum,

Thank you for using Code Tags.

The attached file and code associated with post #2 in the following thread may help you: http://www.excelforum.com/showthread.php?t=1027267

Lewis

Hi sujin,

In the future, please upload a sample workbook. That way the responder does not have to reproduce your data, and you will probably get more accurate and faster responses.

if i click the necessary check box,and the command button "export the nfr", the row corresponding to the selected check box should be copied to another sheet, is there any way to add codes for that manipulation

Your question has a few issues:
a. Because you use 'Merged Cells' in Columns 'B' and 'C', the destination area will not look EXACTLY like the source area.
b. See the code in red below that creates the 'Active X' CheckBoxes (identical to the code in the link referenced above).
A 'Linked Cell' for each CheckBox as the cell underneath the CheckBox. The cell has custom formatting of 3 semi-colons [;;;] which hides the contents of the cell.
c. The CheckBox is not copied to the Destination Sheet. Please let me know if you require the Checkbox to be copied.

CheckBox Creation Code:

Please Login or Register  to view this content.

See the attached file which was created in Excel 2003. Active 'X' controls do not transport well between Excel versions or across state lines or International borders. I deleted all the 'Active X' CheckBoxes on 'Sheet1'. Before you use the attached file, you will have to add the 'Active X' CheckBoxes in Column 'E' using the Cyan Colored CommandButton.
The following code in Ordinary Code Module ModCopyRows:

Please Login or Register  to view this content.

It is a best practice to declare all variables. If you misspell a variable in your code, VBA will silently assume it is a Variant variable and go on executing with no clue to you that you have a bug. Go to the VBA development window, click Tools, Options, and check "Require Variable Declaration." This will insert the following line at the top of all new modules:

Please Login or Register  to view this content.

This option requires all variables to be declared and will give a compiler error for undeclared variables.

Lewis