+ Reply to Thread
Results 1 to 9 of 9

Reset Drop Lists When Click on first list

  1. 10-28-2013, 05:17 AM #1
    work4nutz
    work4nutz is offline
    Registered User
    Join Date
    11-18-2012
    Location
    Pville,LA
    MS-Off Ver
    Excel 2010
    Posts
    16

    Question Reset Drop Lists When Click on first list

    ok heres what im tring to accomplish,

    B2 drop list changes values in B9:B18
    D9:D18 drop lists based off of values from B9:B18
    when click on B2 list i would like D9:D18 to revert to first item on list

    just wondering if this would be possible to do and if so how to do it,

    drop list in B2 has nothing to do with drop lists D9:D18
    Reply With QuoteRegister To Reply
  2. 10-28-2013, 10:29 PM #2
    work4nutz
    work4nutz is offline
    Registered User
    Join Date
    11-18-2012
    Location
    Pville,LA
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Reset Drop Lists When Click on first list

    heres a screenshot of what i would like to be able to do

    excelScreenshot_1.png
    Reply With QuoteRegister To Reply
  3. 10-28-2013, 11:09 PM #3
    BrianM45
    BrianM45 is offline
    Forum Contributor
    Join Date
    05-10-2012
    Location
    Paris, France
    MS-Off Ver
    2016/365
    Posts
    123

    Re: Reset Drop Lists When Click on first list

    Hi work4nutz

    just wondering if this would be possible to do and if so how to do it,
    Yes it's possible with VBA, do you Know ?
    Reply With QuoteRegister To Reply
  4. 10-29-2013, 04:11 AM #4
    work4nutz
    work4nutz is offline
    Registered User
    Join Date
    11-18-2012
    Location
    Pville,LA
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Reset Drop Lists When Click on first list

    Quote Originally Posted by BrianM45 View Post
    Yes it's possible with VBA, do you Know ?
    havent used VBA in like 15 yrs and remember nothing
    Reply With QuoteRegister To Reply
  5. 10-29-2013, 10:55 AM #5
    BrianM45
    BrianM45 is offline
    Forum Contributor
    Join Date
    05-10-2012
    Location
    Paris, France
    MS-Off Ver
    2016/365
    Posts
    123

    Re: Reset Drop Lists When Click on first list

    Hi,

    Can you share your Workbook ?
    If NO, i'm sorry but i can't help you
    Reply With QuoteRegister To Reply
  6. 10-29-2013, 02:16 PM #6
    work4nutz
    work4nutz is offline
    Registered User
    Join Date
    11-18-2012
    Location
    Pville,LA
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Reset Drop Lists When Click on first list

    Quote Originally Posted by BrianM45 View Post
    Can you share your Workbook ?
    If NO, i'm sorry but i can't help you
    cant upload here file to large
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  7. 10-29-2013, 02:20 PM #7
    work4nutz
    work4nutz is offline
    Registered User
    Join Date
    11-18-2012
    Location
    Pville,LA
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Reset Drop Lists When Click on first list

    https://www.dropbox.com/s/h772dmezts...lc%20test.xlsx you can try to get it from here
    Reply With QuoteRegister To Reply
  8. 10-29-2013, 02:37 PM #8
    BrianM45
    BrianM45 is offline
    Forum Contributor
    Join Date
    05-10-2012
    Location
    Paris, France
    MS-Off Ver
    2016/365
    Posts
    123

    Re: Reset Drop Lists When Click on first list

    Thanks

    Copy the code below 
    Please Login or Register  to view this content.
    Keys ALT+F11 you enter in VBA Project
    Double click in feuille1 (Legion Calc) to access the code
    Paste the code above

    Save Workbook as "Legion Calc test.xlsm" with extension ".xlsm" for macros
    Last edited by BrianM45; 10-29-2013 at 02:42 PM.
    Reply With QuoteRegister To Reply
  9. 10-29-2013, 02:43 PM #9
    work4nutz
    work4nutz is offline
    Registered User
    Join Date
    11-18-2012
    Location
    Pville,LA
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Reset Drop Lists When Click on first list

    works just like i wanted thanks for the help
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Dependent Drop Down Lists, Data Validation, Reset Dependents
    By daxlyon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-12-2013, 11:15 AM
  2. [SOLVED] VBA code to click/select drop down lists
    By hockeyadc in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 07-26-2013, 12:19 PM
  3. Macro to reset choices in dynamic drop down validation list to choice at top of each list
    By Jonno1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-15-2013, 09:22 AM
  4. How to reset all controls (Drop Down list on a sheet)
    By tariq in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2007, 08:06 AM
  5. Drop Down List Titles As Default And Reset Button
    By travelersway in forum Excel General
    Replies: 0
    Last Post: 10-17-2005, 12:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1