How to mimic ctrl-select using multiple checkboxes on a form

**vbapadawan** · 07-05-2015, 04:59 PM

I have a userform that is auto populated with checkboxes that correspond to column headings on an activeworksheet.
what i want to do is click any combination of checkboes, when I click the command button it selects/copy the column(s) the checkbox relates to so I can then click another command button to open a new worksheet and paste the selection.
Unfortunately my code will only allow me to select one column at a time and not multiple. please help me, I've spent two days trying to get this to work, i think i have to somehow dd each checkbox to an array or range?

below is the command button

Please Login or Register  to view this content.

**Norie** · 07-05-2015, 07:19 PM

Use a listbox.

**AlphaFrog** · 07-05-2015, 07:59 PM

Change this...

Please Login or Register  to view this content.

To this...

Please Login or Register  to view this content.

**vbapadawan** · 07-06-2015, 07:19 AM

OMG.....it worked....thank you so much AlphaFrog
oops, I have added a heading and would like to only copy from row5 to end of row not entire column, is that possible?

would this also work with a listbox setup?

**vbapadawan** · 07-06-2015, 04:38 PM

How would you use a listbox to accomplish this task Norie?
I have started to build one, i have been able to populate the list with the column headings from the activesheet, but am not sure how to link those to the active sheet to make a selection/copy as with the checkboxes;
i will then have a command button to export the selection to a new sheet, but am unsure how to paste them side-by-side on the new sheet?

**AlphaFrog** · 07-06-2015, 05:07 PM

Please Login or Register  to view this content.

**vbapadawan** · 07-06-2015, 07:00 PM

I am So Close AlphaFrog I can taste it, but I do not want to copy the entire column only from row 5 to end row for each selection (my buttons and other data is on row 1 to 4 which I don't want transferred).
I also have auto filtered abd non-autofiltered information.
I have another button that exports the entire sheet, but would prefer the listbox feature.
how can this be acheived?
the code for the other button is beolw and it workd with filtered or non-filtered sheets

Please Login or Register  to view this content.

**AlphaFrog** · 07-06-2015, 07:22 PM

Please Login or Register  to view this content.

**vbapadawan** · 07-07-2015, 02:53 AM

You're a legend AlphaFrog, thank you so much. I'd shout you a beer if you were here.

How to mimic ctrl-select using multiple checkboxes on a form

LinkBack

Thread Tools

Rate This Thread

Display

How to mimic ctrl-select using multiple checkboxes on a form

Re: How to mimic ctrl-select using multiple checkboxes on a form

Re: How to mimic ctrl-select using multiple checkboxes on a form

Re: How to mimic ctrl-select using multiple checkboxes on a form

Re: How to mimic ctrl-select using multiple checkboxes on a form

Re: How to mimic ctrl-select using multiple checkboxes on a form

Re: How to mimic ctrl-select using multiple checkboxes on a form

Re: How to mimic ctrl-select using multiple checkboxes on a form

Re: How to mimic ctrl-select using multiple checkboxes on a form

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Ctrl + Select for multiple selection of cells in VBA

.Select selecting multiple sheets in a form

Auto Disappear of all checkboxes in 2 form except selected value from combobox in 1 form

Disable cut,copy,paste(including ctrl x, ctrl c n ctrl v)

Userform coding to mimic Form Button

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions