+ Reply to Thread
Results 1 to 6 of 6

Use checkbox to select language and filter data

  1. #1
    Registered User
    Join Date
    02-27-2019
    Location
    Belgium
    MS-Off Ver
    2013
    Posts
    5

    Question Use checkbox to select language and filter data

    Hello everyone!

    I have an excel document containing 2 tables with descriptions in 2 languages and corresponding prices.
    My goal is to have the data filtered when I check a language in the checkbox.
    After filtering, I want to be able to select the items in the checked language using a data validation drop down menu.
    It sounds simple, but I've been trying for hours and it just won't work...

    Thank you in advance
    Sebastiaan
    Attached Files Attached Files
    Last edited by SebastiaanKer; 02-27-2019 at 09:54 AM.

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    1,904

    Re: Use checkbox to select language and filter data

    Hi

    Can you able attach some example file, please?
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Registered User
    Join Date
    02-27-2019
    Location
    Belgium
    MS-Off Ver
    2013
    Posts
    5

    Re: Use checkbox to select language and filter data

    I wish I could, but it's information I cannot share...
    I'll quickly make a mock file!


    I added it! Hope you get it :D
    Last edited by SebastiaanKer; 02-27-2019 at 09:54 AM.

  4. #4
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    1,904

    Re: Use checkbox to select language and filter data

    As first I suggest to use radio button not checkbox. English OR French.
    Check attached file. I've connect radio buttons into the same cell (so choice is as above, Fr or Eng).
    Base on choosen language data validation to the cell displays English or French description of products.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    02-27-2019
    Location
    Belgium
    MS-Off Ver
    2013
    Posts
    5

    Re: Use checkbox to select language and filter data

    It's great to have a working example, I'll be able to figure it out
    Thanks a lot!!

  6. #6
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    1,904

    Re: Use checkbox to select language and filter data

    You welcome.
    If you happy with solution, please use thread tools and mark thread as SOLVED.

+ 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] VBA Select Entire Row if Checkbox AND Select Down Until Next Checkbox
    By phelbin in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-01-2016, 01:13 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. Select All Checkboxes Checkbox That Also Calls Checkbox Macros
    By Intervigilium in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-23-2015, 06:41 PM
  4. [SOLVED] Using checkbox to filter multiple data, want to delete multiple data instead of filter dat
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-23-2014, 11:52 AM
  5. Replies: 0
    Last Post: 04-07-2014, 12:22 PM
  6. Replies: 2
    Last Post: 04-19-2010, 04:20 AM
  7. filter data on all worksheets using checkbox on userform
    By macximus in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-09-2008, 03:33 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