+ Reply to Thread
Results 1 to 4 of 4

combo box to ignore list

  1. #1
    Registered User
    Join Date
    01-02-2018
    Location
    Iowa
    MS-Off Ver
    2017
    Posts
    27

    combo box to ignore list

    I have a userform with a combo box on it that shows the worksheets in the workbook. What is selected is then saved to sheet 'A' column 'A'. I have a NameRange that is not dynamic called 'used_sheets' that lists all the sheets that have been selected. How can I get that userform Combobox list to ignore the sheets already listed in column 'A'
    Such when I select sheet 'H' and it's listed in column 'A', the next time I use that combobox it will not list sheet "H".
    The code for the combobox is
    Please Login or Register  to view this content.

    Attached is a sanitized workbook
    Attached Files Attached Files

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,158

    Re: combo box to ignore list

    Slight change...
    Please Login or Register  to view this content.
    And at end of Save Button Code...Add red snippet

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Registered User
    Join Date
    01-02-2018
    Location
    Iowa
    MS-Off Ver
    2017
    Posts
    27

    Thumbs up Re: combo box to ignore list

    tried it and it WORKS just as I wanted
    THANKS

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,158

    Re: combo box to ignore list

    Glad I could help...tx for the rep +

+ 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] Combo Box Drop down list shows complete list but in excel it does not
    By amartin575 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-04-2020, 09:02 AM
  2. How to ignore empty combo box and continue with code
    By sy898661 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-18-2019, 01:43 PM
  3. [SOLVED] Based on data from combo box , list range of value to another combo box / listbox
    By ajupillai in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-21-2016, 03:35 AM
  4. Dependant ActiveX Combo Box list based on Data Validation List
    By spalmer28 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-12-2014, 07:57 AM
  5. [SOLVED] Fill combo box list based on other combo box values
    By rain4uu in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-23-2013, 03:04 PM
  6. VBA combo boxes (ignore blanks + avoid duplicates)
    By pbobadilla in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-12-2012, 05:44 PM
  7. Filtered list for Combo Box ListFillRange - Nested Combo Boxes
    By DoctorG in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-23-2006, 08:20 AM

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