Sorting check Boxes in alphabetical order

Hi All

Been searching to no avail....How can one sort checkboxes with labels in alphabetical order. Pls see uploaded sample.

Hello Mr. Sintek
What about using the sort feature in excel? Does it work for you?
Select the range("A1:B4") >> Sort from Data tab A to Z >> sort by column B

Hi YasserKhalil

Just realised that the CheckBoxes must be same name as cell then this code will work....Sort feature was not working as this was not done...

Please Login or Register  to view this content.

Glad you can solve it ..
Here's my try

Please Login or Register  to view this content.

As for your code you used if in this line

Please Login or Register  to view this content.

and in your sample workbook the name of the checkboxes will not be the same as the cell value >> or you have changed the name manually for each checkbox

Yep, was gonna change manually but decide to do this way instead...

Please Login or Register  to view this content.