I'am trying to sort Checkbox but can't manage to do it using VBA.
What I have done so far is the following:
- Add checkboxes using VBA to span a cell [CODE] ActiveSheet.CheckBoxes.Add(MyLeft, MyTop, MyWidth, MyHeight).Select
- Select a range in a sheet and by using Sort and Filter button - Custom sort then default options ( A column - By value - From A to Z)
- A Macro has been set for each checkbox
This way the column in which I have the Checkboxes are sorted correctly.
My problem is that using VBA to sort the range using Macro Recorder does not sort my checkboxes.
Someone has an idea ?
The goal is to take several tables, merge then sort them. Checkboxes.xlsm
Bookmarks