$$Excel-Macros$$ Re: Export selected worksheets into new workbook from list box

2009-05-18 Thread Senthil Kumar Palani
hi all, i want to learn VBA Macros, can anybody send example excel file and macro file, kindly do the need ful thanks Regards, kumar On Thu, May 14, 2009 at 10:01 PM, Steve klein.st...@gmail.com wrote: I have a UserForm with a multi-selection ListBox (ListBox1) that is populated with all

$$Excel-Macros$$ Re: Export selected worksheets into new workbook from list box

2009-05-15 Thread bala
hi your code process all the sheets listed in list box, check if List22.Selected (x) = true then selected value do the process Private Sub CommandButton1_Click() Dim Lst As String Dim x As Long For x = 0 To ListBox1.ListCount - 1 If ListBox1.Selected(x) = True Then Lst

$$Excel-Macros$$ Re: Export selected worksheets into new workbook from list box

2009-05-15 Thread Steve
Thank you for the help! On May 15, 1:53 am, bala bal...@gmail.com wrote: hi your code process all the sheets listed in list box, check if List22.Selected (x)  = true then selected value do the process Private Sub CommandButton1_Click() Dim Lst As String Dim x As Long     For x = 0 To