+ Reply to Thread
Results 1 to 3 of 3

Reset Dependent Data Validation selections without macros?

  1. #1
    Registered User
    Join Date
    09-07-2012
    Location
    VA
    MS-Off Ver
    Excel 2007
    Posts
    20

    Reset Dependent Data Validation selections without macros?

    I have data validation drop down selections in Columns A and B and C, where B is dependent on the selection in A and C is dependent on B (left to right, if you will). This works very well, but I have noticed that when I change my selection in A, the previously selected items in B and C remain. Is there a way to remove the selections (to blank cells) when any item to the left is removed or changed? For instance, if the user deletes or changes their first selection in A, B and C go blank. Or when they delete or change their selection in B, C goes blank. I'm aware of a simple macro that does this, but it seems to me that there exists a formula I could enter into the data validation or list names window that will do the trick. Any ideas?

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Reset Dependent Data Validation selections without macros?

    Is this solved?

    If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    09-07-2012
    Location
    VA
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Reset Dependent Data Validation selections without macros?

    Actually, I think I acted a little too soon. I thought I had a solution where I could simply use this formula in the list definition for B2: "=IF(A2="","", Indirect(A2))", but it didn't work.

    I fear Macros are required; I just need a way to retain them when I split the workbook. See this thread.

    If anyone knows a way to reset these values without a macro, please chime in. If it isn't possible without VBA, then I still need a solution to the question in the thread linked above.
    Last edited by Eric09; 09-20-2012 at 07:55 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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