+ Reply to Thread
Results 1 to 3 of 3

filter by double clock on item

  1. #1
    Forum Contributor
    Join Date
    11-18-2014
    Location
    alex
    MS-Off Ver
    excel
    Posts
    135

    filter by double clock on item

    I want to filter item once I double click on it
    Attached Images Attached Images

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: filter by double clock on item

    There is no such functionality to filter by double-click unless you use VBA
    Here is how you can do it:
    1. Right-Click on the cell that you want to filter.
    2. Select Filter from the menu and from the sub-menu click on Filter by Selected Cell's Value.
    Last edited by AlKey; 01-09-2017 at 02:21 PM.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Forum Contributor
    Join Date
    11-18-2014
    Location
    alex
    MS-Off Ver
    excel
    Posts
    135

    Re: filter by double clock on item

    yes I want this vba code

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Extract Numbers between double quotes and after Item#
    By rehana402003 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 01-01-2016, 04:18 PM
  2. Running Clock/Automatically Filter Merged Cell Rows
    By hwtcrl in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-30-2014, 04:15 PM
  3. [SOLVED] Filter by item, based on max value for that item ??
    By msuspartans in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-06-2013, 08:49 PM
  4. Double click Listbox to edit item
    By johan12 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-22-2012, 04:12 AM
  5. List box Double Click Copy and remove item
    By thameem127 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2012, 05:00 PM
  6. Need selected item from listbox after double click
    By peterfarge@hotmail.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-23-2006, 11:20 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1