+ Reply to Thread
Results 1 to 2 of 2

Advanced Filter Macro Not Load Automatically When Using Combo Box

  1. #1
    Registered User
    Join Date
    01-26-2013
    Location
    Vientiane
    MS-Off Ver
    Excel 2013
    Posts
    4

    Advanced Filter Macro Not Load Automatically When Using Combo Box

    I'm very new to this. Can someone please advise. I can't seem to make the macro run automatically for some reason. It has to be manually run.
    1. Select from the drop down list in combo box (Value Must be a string & not number) The code below is just some code i found on net
    2. Have a macro called filter_stuff output the results from a linked table
    3. I need the macro to run automatically when when a value is selected from the combo box

    A similar link to the same problem can be found here: http://www.excelforum.com/excel-prog...mbo-boxes.html

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Would a kind soul please shed some light on this matter.

    Do advise where to paste the code in (Sheet, Module) etc. I'm really new and keen to learn

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,598

    Re: Advanced Filter Macro Not Load Automatically When Using Combo Box

    1. In the worksheet change module, you have two End Sub's; you can have only one, and it is the last line in the macro.
    2. Unless the active cell is E9, No code after the line:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    will be executed. Therefore, the statement:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    is unnecessary.

    Also, E9 is the address of the active cell, not it's contents.

    One way to check if the active cell is a specific cell is:
    If Target.Address ="$E$9
    (in this case, no such test is necessary because of the .Intersect line.)
    Last edited by protonLeah; 01-27-2013 at 03:31 PM.
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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