macro to copy Wks selected using a userform

**Andy Pope** · 10-10-2008, 04:06 AM

Userform with Listbox and 2 commandbuttons

Please Login or Register  to view this content.

**CCRUZ277** · 10-10-2008, 07:32 AM

I have a workbook with many worksheets and some times I need copy some of them to a new workbook .
what I need is a macro to copy the wks but first show me userform with all the existents sheets in this workbook and request my choice with a check box 's

**Andy Pope** · 10-10-2008, 08:06 AM

Did you keep a copy of the code I posted in your other thread?

**arthurbr** · 10-10-2008, 08:09 AM

Sorry everybody, Andy's answer is before the OP's question. Please read form the bottom up

**Andy Pope** · 10-10-2008, 08:15 AM

thanks arthurbr, I was just about to redo that code.

Although I now have a count of 1 for forum threads started

**CCRUZ277** · 10-10-2008, 08:54 AM

I have a workbook with many worksheets and some times I need copy some of them to a new workbook .
what I need is a macro to copy the wks but first show me userform with all the existents sheets in this workbook and request my choice with a check box 's.
I use the code from Andy Pope "Userform with Listbox and 2 commandbuttons" But didn't copy or at least the way I did and I also think the list of Chek box's Would be fit beter my needs because this way I could choose the wks that I want to copy

Many thanks
ccruz

**Andy Pope** · 10-10-2008, 09:56 AM

One think I left off is that you need to set the listbox to have multi or extended selection.

macro to copy Wks selected using a userform

LinkBack

Thread Tools

Rate This Thread

Display