Using checkboxes to delete specific ranges of cells via command button

Hello everyone,

I am quite new to the forum, and although I have read the rules, please do let me know if I am breaking any. This is my first post, after all.

I am extremely new to VBA and excel formulae and until very recently the most advanced procedure I was able to complete with Excel was sketching a scatter plot. I am compiling a database of sorts to serve me during my PhD. Through browsing the net for tutorial videos and forum posts, I was able to put together a VBA advanced filter, create a dynamic scatter plot and box plot with several useful functions, and a few very very simple macros to tidy the whole thing up.

I am finding it difficult to navigate through my filtered data at times because there are simply too many columns. Sometimes I want to delete certain columns (not entire columns but cell ranges starting at row 29) so that I only have the data I need. This is simply enough done manually, however, I am not the only person to use the database, therefore I want to make it as straightforward as possible. What I want is to have checkboxes above each column header of my filtered data which I could check and then use a command button to delete the selected columns/cell ranges and shift the remaining cells left so there are no blank spaces. Needless to say, I need my advanced filter macro to still function after the columns have been deleted.

I found a similar solution to what I want, which deletes entire rows in this thread. I don't know, however, how to adapt the solution to my needs.

I have uploaded my current database for anyone to have a look.

Any and all help would be much appreciated

Click on a few cells in row 27 and then click on green button in B27 and the contents of those columns are cleared.

I did not know which columns of data to move to left. Not enough detail provided
Please write out rule for which data is supposed to move leftwards after columns cleared (not all data the same, so are the numbers in groups?)


1) Checkbox is mocked up by using the Marlett Font (in this font "a" looks like a "tick") . Much more flexible than traditional checkboxes!
So click on any cell in range C27:AB27 and a tick will appear. Click again and it disappears
The code that provides the (mock) checkbox is this

Please Login or Register  to view this content.

2) Colums cleared if tick (ie "a") in row 27, using this macro

Please Login or Register  to view this content.

thanks for adding to my reputation
if you have all the answers you need please mark the thread as solved.
kev