+ Reply to Thread
Results 1 to 8 of 8

When Cascading List returns to default

  1. #1
    Forum Contributor
    Join Date
    06-27-2014
    Location
    Margate, FL
    MS-Off Ver
    MS Office 2016
    Posts
    215

    When Cascading List returns to default

    Hello,

    I'm working on a form that has a cascading list. My first list has 3 categories (vendors, subcontractor and customers). My second list has the names of either of them depending on what I choose from the first list. The trouble I'm having is that when I switch to thru the first list, my second list doesn't go blank as i would like it to. Instead it keeps the previous info from what i chose before it.

    For example: In the form attached, I clicked on VENDORS on cell J3 and I got Home Depot on cell E6. When I switch to another category in J3, Home Depot in cell D6 doesn't go away. How do I fix this?


    Thank you so much.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: When Cascading List returns to default

    Put this in the "Form" sheets module
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    06-27-2014
    Location
    Margate, FL
    MS-Off Ver
    MS Office 2016
    Posts
    215

    Re: When Cascading List returns to default

    That didn't work.

    All I had to do was click ALT-F11 and copy and paste the code into the screen right? it went into (General)... Worsksheet_Change.

  4. #4
    Forum Contributor
    Join Date
    06-27-2014
    Location
    Margate, FL
    MS-Off Ver
    MS Office 2016
    Posts
    215

    Re: When Cascading List returns to default

    When I switch the categories, cell D6 should clear out and its not.

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,891

    Re: When Cascading List returns to default

    See here, pasted into correct place.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  6. #6
    Forum Contributor
    Join Date
    06-27-2014
    Location
    Margate, FL
    MS-Off Ver
    MS Office 2016
    Posts
    215

    Re: When Cascading List returns to default

    I only see the previous code that was already in there for the spellnumber.. I'm sorry I dont know much about VBA..

  7. #7
    Forum Contributor
    Join Date
    06-27-2014
    Location
    Margate, FL
    MS-Off Ver
    MS Office 2016
    Posts
    215

    Re: When Cascading List returns to default

    never mind. I found it thank you.

  8. #8
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: When Cascading List returns to default

    Right click on the Form sheet tab > select View code > paste the code into the window that opens up.

+ 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. Cascading drop down list
    By antros48 in forum Excel Formulas & Functions
    Replies: 26
    Last Post: 07-04-2019, 08:02 AM
  2. Combobox and VBA Dependent List / Cascading List
    By ninopolletta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-23-2018, 11:56 PM
  3. hiding a cascading drop down list
    By silverdan7 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-09-2013, 12:06 AM
  4. [SOLVED] CASCADING LIST BOX
    By GASHD1889 in forum Excel General
    Replies: 2
    Last Post: 11-02-2005, 06:17 PM
  5. Create a cascading list box using Excel
    By JPB in forum Excel General
    Replies: 1
    Last Post: 02-24-2005, 05:06 PM
  6. Cascading List Boxes
    By garageflower in forum Excel General
    Replies: 1
    Last Post: 02-11-2005, 06:04 AM
  7. Cascading List Boxes
    By garageflower in forum Excel General
    Replies: 0
    Last Post: 02-10-2005, 02:50 PM

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