+ Reply to Thread
Results 1 to 4 of 4

Dropdown list minor issue

  1. #1
    Registered User
    Join Date
    04-25-2017
    Location
    Bulgaria
    MS-Off Ver
    2016
    Posts
    11

    Dropdown list minor issue

    My B48 cell is a dropdown list type. The dropdown list takes its components from another sheet, and they look like: "=IF('Sheet1'!B47 = "no";"answer 1/2/3";"")"
    So the B48's list has values only when the value of B47 is "no".
    The problem is the following:
    When B47 is "no", and you choose one of the answers available in B48, and then you change B47 to "yes" - the value of B48 remains. It doesn't update automatically.
    Is there any way I can "fix" this?

    Edit: hiding row 48 when B47 is different than "no" is also an option, but I don't know if I can do that either (or how).
    Last edited by WereElf; 04-30-2017 at 11:57 AM.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Dropdown list minor issue

    You can use a WOrksheet_Change event to watch for manual edits to cell B47, clearing B48 when it is changed to "yes".

    This macro goes into the sheet module, you'll have to merge this functionality into any existing _Change event if one is there already.

    Please Login or Register  to view this content.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    04-25-2017
    Location
    Bulgaria
    MS-Off Ver
    2016
    Posts
    11

    Re: Dropdown list minor issue

    Okay, I created this macro, changed my file to xlsm (from xlsx), enabled macro using.
    And it doesn't work. Do I need to attach the macro to my sheet or something? And if yes - how?

    EDIT: Oh, my bad (ofc... I'm totally new to using VBA script) I had created a Module with this script, instead of writing it into Sheet1's code :P
    Last edited by WereElf; 04-30-2017 at 02:40 PM.

  4. #4
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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] Excel VBA email to Outlook; CC issue (Minor)
    By yawwwn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-14-2015, 05:13 AM
  2. Minor formatting issue: allow capturing a (.) full-stop as decimal
    By onmyway in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-13-2015, 03:34 AM
  3. Userform Macro need minor adjustments to code (Populate Textbox and Combobox Return Issue)
    By jaredmccullough in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-15-2014, 08:07 AM
  4. ERROR 91 - Prolly Minor Issue, but i cant figure it out. - Object variable not set.
    By Excel_Phil in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-09-2013, 03:24 PM
  5. Replies: 1
    Last Post: 10-25-2010, 08:29 PM
  6. Replies: 21
    Last Post: 12-02-2009, 03:27 PM
  7. Having a minor issue with SUM and AVERAGE
    By IronDogg in forum Excel General
    Replies: 3
    Last Post: 11-16-2008, 12:51 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