Can check boxes be included in sorting, using VBA

I wish to sort a worksheet with a range B6:T50, based on column C. The sorting will be ascending alphabetically.
My problem is that columns B and T have Active X Control checkboxes, and I have noted that they do not sort with the rest of the data.
Is it possible, via a macro, to include the check boxes when sorting?
Thanking you all in advance.

Hi shg,

I have 2 columns of checkboxes on the one sheet. At the moment both columns are using Active X control checkboxes, but I want to replace both columns with Marlett checkboxes.
The check boxes are located at B6:B50 & T6:T50.
Using the above code and the Marlett font, I was able to successfully add the Marlett checkboxes to B6:B50. The name of the Range B6:B50 is 'Current'.
My problem now is that I'm not sure how to update the code to incorporate the Marlett checkboxes in the second coloumn T6:T50.
The name of the range T6:T50 is 'NotinUse'.

That's correct. Same behavior for both columns.

The second code shows the user, the status selected. In the case of B6:B50 the 2 states are 'Current' & 'Non-Com' (short for Non-Compliant).
The second column T6:T50 will also have a second code. It's offset cell will read 'Not in Use' if selected and remain blank if not selected.

Excellent shg. It works a treat. Thanks.
I’m now having trouble with the second lot of code. I thought I might be able to handle it, but as I only tinker with Excel, it’s a bit beyond me.

The code in question is:

Please Login or Register  to view this content.

The above code works well for the first column of Marlett checkboxes B6:B50 (Range Name: ‘Current’).
I would like to add the same behaviours, in the above sub, to the second column of Marlett checkboxes T6:T50 (Range Name: ‘NotinUse’).


Below is some code which illustrates what I’m after.

Please Login or Register  to view this content.

Thanks again for your help.

I actually haven't completed the code.
I started with a compile error. I resolved this when I learned I had the sub name in twice.
I'll look over what you have sent and post a result soon.

Thanks.

I have acheived a result.

Please Login or Register  to view this content.

Do you think it needs any changes, as I have noticed that we novices tend to add superfluous lines to our code.

Perfect.
Thanks again for all your help.