Hello,
I'm having difficulty coming up with vba to copy the filtered contents in a multi-column listbox "ListBox1" to a new workbook. I would like to achieve this via CommandButton "Export" located in UserForm frmAAGReport". Can anyone offer some insight?
P.S. - I would attach a sample workbook but can not find where I can include an attachment. Not sure if it's because I'm a new member.
Thank you.
I'm having difficulty coming up with vba to copy the filtered contents in a multi-column listbox "ListBox1" to a new workbook. I would like to achieve this via CommandButton "Export" located in UserForm frmAAGReport". Can anyone offer some insight?
P.S. - I would attach a sample workbook but can not find where I can include an attachment. Not sure if it's because I'm a new member.
Thank you.