+ Reply to Thread
Results 1 to 3 of 3

Unhide specified sheers based on selection with combobox in a userform

  1. #1
    Registered User
    Join Date
    06-27-2018
    Location
    nopetown
    MS-Off Ver
    2016
    Posts
    3

    Red face Unhide specified sheers based on selection with combobox in a userform

    Hi Excellovers and VBA cracks,

    first of all I want to thank a lot of guys in this forum. I gathered a lot of informationen and found out that in most cases,
    I am not the only one searching a solution for the same problem.

    This time I really need your help. So thank you in advance for all the answers.

    The Problem I want to solve is.

    I have 6 comboboxes in a UserForm with possible selections from 1 to 20.
    Selection is done to unhide Sheets with predefined Sheetnames.

    Let's say the comboboxes are for Productcategories:

    We have

    Cars
    Boats
    Bicycles
    Motorbikes
    Trailers
    And so on

    If we Select Cars and the value in the combobox 10, then the following Sheets should be unhided:
    Cars1,Cars2,Cars3-----,Cars10
    If we select Boats and the value 2 -> Boats1 and Boats2 should be visible.
    (Cars should still be display, becaue the value 10 was entered in the combobox of cars.)

    This will be used as kind of a configtemplate before working in the actual sheets.

    If you need further information please let me know. Sorry for the long text.

    Susi

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Unhide specified sheers based on selection with combobox in a userform

    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    06-27-2018
    Location
    nopetown
    MS-Off Ver
    2016
    Posts
    3

    Re: Unhide specified sheers based on selection with combobox in a userform

    Thank you so much. I will try this in the office in around 1 hour. Amazing.

    I hope I did not write my request wrong, but I have 6 comboboxes, one for each category,
    for example cars and the values in the comboboxes are 1 to 20.
    All Sheets <> MainSheet are hided when opening the file.

+ 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] userform display based on combobox selection
    By russkris in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-21-2016, 10:40 PM
  2. [SOLVED] Userform: Change Combobox list based on a second ComboBox selection
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-11-2016, 03:45 PM
  3. ComboBox values source being changed based on another combobox selection in a UserForm
    By stephenanderson in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-08-2016, 11:12 PM
  4. [SOLVED] Userform textbox value based on combobox selection
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-17-2014, 11:56 AM
  5. Userform Combobox to populate based on selection in another combobox
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2014, 03:34 PM
  6. [SOLVED] How VB code can unhide/hide rows based on combobox selection?
    By jgomez in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-04-2012, 01:25 PM
  7. Populating a userform based on a combobox selection
    By blindzero678 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-22-2010, 03:37 PM

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