Shortz
04-13-2010, 05:09 AM
Hi everyone,
I have a two part question,
Part A
I have a question about listboxes and their use.
1. I have a listbox and the user makes their choices (easy no worries coding wise)
2. What is the best way to output those values into a temporary hidden worksheet?
Currently i get them all output then select from the top until row 300 then use xlspecialcells to remove blanks.
3. I wish to use the selections to filter values in a range on another worksheet
Part B
This relates to searching and may be similar to Part A.
eg. Say i have 10 selections possible and i want to filter some data, moving along columns (or rows) to remove all values except where the values equal 3 of selections. What is the best way to achieve this?
Basically, i want to make my selections in the listbox, output those to a temporary sheet then search through my intended range deleting values that don't match the selected values.
I have included a spreadsheet to include what i'm trying to achieve (minus the forms and listboxes) for both parts. And i'm using excel 2003.
thanks in advance for any and all of your help.
I have a two part question,
Part A
I have a question about listboxes and their use.
1. I have a listbox and the user makes their choices (easy no worries coding wise)
2. What is the best way to output those values into a temporary hidden worksheet?
Currently i get them all output then select from the top until row 300 then use xlspecialcells to remove blanks.
3. I wish to use the selections to filter values in a range on another worksheet
Part B
This relates to searching and may be similar to Part A.
eg. Say i have 10 selections possible and i want to filter some data, moving along columns (or rows) to remove all values except where the values equal 3 of selections. What is the best way to achieve this?
Basically, i want to make my selections in the listbox, output those to a temporary sheet then search through my intended range deleting values that don't match the selected values.
I have included a spreadsheet to include what i'm trying to achieve (minus the forms and listboxes) for both parts. And i'm using excel 2003.
thanks in advance for any and all of your help.