Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 178
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 178
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adapting VBA Code smurray444 Excel Programming 1 July 27th 07 05:28 PM
Adapting MAX function nir020 Excel Worksheet Functions 4 September 25th 06 04:53 PM
Please Help Adapting this Macro Paul Black Excel Programming 1 September 3rd 06 03:17 PM
Adapting some code chrisrowe_cr[_6_] Excel Programming 4 August 16th 05 01:18 PM
Repost: Worksheet Change Method (Bob Philips, Ron De Bruin) Michael[_11_] Excel Programming 2 August 8th 03 01:16 PM


All times are GMT +1. The time now is 08:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"