Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adapting your Unique Value method Attn: Ron de Bruin
Good Afternoon/Evening in the Netherlands Ron! If you ever want me to
just go away or grow tired of helping me, just say so. I do plan on making a contribution to your website once monies allow. I have an idea that you might find interesting and would require adapting your unique value macro to create new workbooks and worksheets. The starting spreadsheet has values in multiple columns. One of the columns has a header with the value Supervisor_Name. Assume there is already a userform named SupervisorFilter with two list boxes and a command button. When SupervisorFilter.Show is initiated, I'd like the list of supervisors to appear in the left listbox and when double clicked, a value would move over to the right listbox. Once the commandbutton1 is pressed all data for the remaining supervisors in listbox1 (on the left) will be deleted and the remaining supervisor data is condensed with no blank rows. What do you think? Are you up for the challange? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adapting your Unique Value method Attn: Ron de Bruin
Ron, I found your EasyFilter on your webpage and this does everything
and then some. But I am limited to only five selections in the Equal- Not Equal tab. Perhaps the listbox idea could be implemented in your EasyFilter application to remove this limitation. Clicking a value in the listbox highlights it, then the Equals or Does Not Equal radio button uses whatever highlighted values from the listbox. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adapting VBA Code | Excel Programming | |||
Adapting MAX function | Excel Worksheet Functions | |||
Please Help Adapting this Macro | Excel Programming | |||
Adapting some code | Excel Programming | |||
Repost: Worksheet Change Method (Bob Philips, Ron De Bruin) | Excel Programming |