+ Reply to Thread
Results 1 to 3 of 3

Activate 2 dropdowns with one command button

  1. #1
    Registered User
    Join Date
    10-16-2012
    Location
    waldorf, maryland
    MS-Off Ver
    Excel 2007
    Posts
    7

    Activate 2 dropdowns with one command button

    Hello!

    I have this on a command button but would like to use 2 drop downs (Drop Down 7 and Drop Down 12) since I have 2 ciriteras for searching (columns 1 and 3). This code filters on selection, then activates or highlights the filtered rows and opens Outlook email (would like to have it work in groupwise) so I can send the filtered rows in body of email. Another thing, if I filter using one drop down, then change to the other nothing will happen. I have a "clear settings" macro that unfilters the data so I can choose from either combo box. It would be nice to switch between the two without having to unfilter data first. Please see below. Thanks!



    This current one is working by itself:

    Please Login or Register  to view this content.

    When I add this I can't get it to work properly:

    Please Login or Register  to view this content.

    Moderator Edit:

    Welcome to the forum, smoot123.

    Please notice that [CODE] tags have been added to your post. The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
    Thanks.
    Last edited by Cutter; 10-21-2012 at 07:08 PM. Reason: Added code tags

  2. #2
    Registered User
    Join Date
    10-16-2012
    Location
    waldorf, maryland
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Activate 2 dropdowns with one command button

    Sorry, will do for future posts. Thanks!

  3. #3
    Registered User
    Join Date
    10-16-2012
    Location
    waldorf, maryland
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Activate 2 dropdowns with one command button

    Okay, the emai function doesn't work in groupwise so I'm wondering if I can do this workaround:

    - Once the data is filtered from my combo box, I'd like to copy only that filtered data and paste (paste all as it has hyperlinks) to a sheet in a new workbook
    - I can then use Excel's "send email as a pdf attachment" which will open my groupwise client at work and attach the workbook

    If I filter using the current workbook and send as an email attachment, it sends the entire workbook instead of just the filtered data. My thought is to send the data to a new workbook and email that. Can this be done with a command button? Suggestions welcome, thanks.

    Fyi, this spreadsheet is a schedule of classes and I'd like to email students the information they request. The spreadsheet has courses with dates, times, cost, location, link to required textbook.
    Last edited by smoot123; 10-22-2012 at 10:18 PM.

+ Reply to Thread

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