Results 1 to 4 of 4

Radio buttons & filtering data

Threaded View

supsup Radio buttons & filtering... 12-14-2006, 03:44 PM
VBA Noob Hi, No attachment VBA... 12-14-2006, 03:46 PM
RobertCo You may need to look at the... 12-16-2006, 12:36 AM
VBA Noob Hi, This example might... 12-16-2006, 03:56 AM
  1. #1
    Registered User
    Join Date
    12-14-2006
    Posts
    1

    Radio buttons & filtering data

    I am trying to learn how to use macros with radio buttons. In the attached "test" file I've listed a simple data table. My goal is to assign a macro(s) to the four radio buttons that would accomplish the following:

    1. By clicking on a radio button, the data will only show the companies/amounts/year that apply

    2. The shown amounts of the companies must be able to sum correctly, and not include the filterer-out companies' amounts

    I know the simple method would be to just use autofilter and subtotal, but I was hoping to get a bit fancy by using macros with run radio buttons to accomplish the procedure.

    I would greatly appreciate any help on this. I'm very new to macros (still reading through textbooks), so please please excuse my ignorance.

    Many thanks!

    ---
    I placed the sample "test" excel file in the zip file
    Attached Files Attached Files
    Last edited by supsup; 12-14-2006 at 06:46 PM.

Thread Information

Users Browsing this Thread

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

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