+ Reply to Thread
Results 1 to 3 of 3

VBA Userform to select checkboxes and extract data based on their filter

  1. #1
    Registered User
    Join Date
    08-09-2016
    Location
    birmingha, england
    MS-Off Ver
    2010
    Posts
    25

    VBA Userform to select checkboxes and extract data based on their filter

    Hi there,

    I currently have a worksheet labelled "Register".

    I have this code whereby it extracts this worksheet and provides the 'save as' option to a folder.

    The worksheet has headers and these headers have filters. The columns: O-U are labelled as follows:

    Column O: Marston Green
    Column P: Test Engineering
    Column Q: West Hartford
    Column R: Singapore
    Column S: Xiamen
    Column T: Neuss
    Column U:Dubai

    The data within these columns are of True/False only and the data begins on row 6.

    I have created a userform interface that when ran allows the user to select a location out of the above via checkboxes and there are also three option buttons: True, False, Both.

    What I'm trying to do with this userform interface is as follows:

    1)

    When you select a location and select True. It will filter True for that location and extract the worksheet.

    When you select a location and select False it will filter False for that location extract the worksheet.

    When you select a location and select BOTH true and false it will just extract the worksheet.

    If one location doesn't have any True/False options and the user selects True/False and presses 'extract' - a notification will come up stating "No true/false options for this location- please amend search".

    2)

    The extracted worksheet doesn't have filters function on. So there are no filters on the extracted worksheet.

    The current coding I have within the userform:

    Please Login or Register  to view this content.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: VBA Userform to select checkboxes and extract data based on their filter

    Hello sdhutty,

    To troubleshoot this problem and provide you with a working solution, you should post a copy of your workbook. If you have any information that is personal or confidential, please change or redact it before you post your copy.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    08-09-2016
    Location
    birmingha, england
    MS-Off Ver
    2010
    Posts
    25

    Re: VBA Userform to select checkboxes and extract data based on their filter

    Hi I am afraid the workbook is too large to create a duplicate workbook.

    I shall try and create another one and send it.

    Is there any idea of how the coding would begin?
    Last edited by sdhutty; 11-25-2016 at 09:12 AM.

+ 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] Filter Excel cells using UserForm CheckBoxes
    By Darkenergyz in forum Excel Programming / VBA / Macros
    Replies: 33
    Last Post: 09-09-2021, 04:08 PM
  2. [SOLVED] Select Automatic Report Filter in Pivot where Filter exist in Data table else select Blank
    By vinaynaran in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-02-2016, 08:47 AM
  3. Userform extract data from sheets based on datepickers and graph results
    By GuitarMyke in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-07-2014, 08:05 AM
  4. [SOLVED] Select checkboxes on a userform to save to PDF and e-mail
    By Kolein in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-22-2014, 10:45 AM
  5. Select series(lines) in a line graph by adding userform with checkboxes on a chart
    By aab_489 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-24-2014, 12:25 PM
  6. Filter data based on data in textboxes in userform and move to a new workbook
    By puuts in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-06-2014, 04:44 PM
  7. Print Sheets based on checkboxes in UserForm, Checkboxes also control another macro
    By krackaberr in forum Excel Programming / VBA / Macros
    Replies: 34
    Last Post: 03-05-2013, 11:12 AM

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