+ Reply to Thread
Results 1 to 8 of 8

DropDown Error Message

  1. #1
    Registered User
    Join Date
    02-06-2018
    Location
    TX
    MS-Off Ver
    2013
    Posts
    38

    DropDown Error Message

    Good Afternoon !!



    Original Question.JPG

    I would like to know if there is a way to combine these two without the use of a VBA as my office has it blocked. I would like to be able to create a dropdown that gives me the same error message as the open text does. This way when I select "No" from the dropdown, I will receive such error message. Please see attached file and thank you in advance. Any assistance is greatly appreciated!!

    Thank You!!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,605

    Re: DropDown Error Message

    In the validation list for B5, can't you just change the (named range) yesno to (a value of) yes? While in the data validation dialog, you can define a popup message via the "Error alert" tab.

  3. #3
    Registered User
    Join Date
    02-06-2018
    Location
    TX
    MS-Off Ver
    2013
    Posts
    38

    Re: DropDown Error Message

    I dont think im following, sorry. You mean to just change the defined name to "yes"? I'm not all that versed in excel as of yet but the given name on the data validation doesnt make a difference, does it? i tried changing the defined name to yes. no change. So i guess what im trying to do is exctly what you pointed out but im not sure how to add two rules on the data validation without using VBAs

    Thank You again for your assistance.

  4. #4
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,605

    Re: DropDown Error Message

    It may be me misunderstanding you, but what I have done is to implement what I was suggesting in post #2 in the attached mod to your workbook.
    So now if you click in B5 the dropdown only gives you a choice of "yes". If you type "no" in B5 then you will get a popup message saying "You must complete the task".

    See the attached workbook and let me know whether it works as you intend it.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    02-06-2018
    Location
    TX
    MS-Off Ver
    2013
    Posts
    38

    Re: DropDown Error Message

    I understand, it took me a while to understand. Would there be a way of incorporating both, "Yes" and "No" in the dropdown ? I understand the solution you're providing and I appreciate it. Would there be any other way of having both in the dropdown with that rule ? I may be asking for too much for just a formula. Sadly I am unable to use any kind of VBA.

    Thank You in Advance

    -jlara0687

  6. #6
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,605

    Re: DropDown Error Message

    A dropdown list is intended to be a list of valid choices that the user can choose from. What you are trying to do, I think, is include "No" in the dropdown list, but if the user then selects "No" then you want to display an error message saying that the user shouldn't have selected "No". That being the case, then why would "No" be in the list in the first place?

    If you are trying to convey that Task Complete should either be "yes" or blank, then would using a checkbox be clearer than using a dropdown list? The attached workbook shows that approach.

    If you really need your original approach then I'm afraid I know of no way (without VBA) to cause the selection of a dropdown list item to generate a popup error. The closest I can think of would be to have some other cell with a formula that checked B5 for "No" and displayed a message. Something like:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Let me know if either of these options would work for you. If not then maybe someone else will pitch in with an idea.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    02-06-2018
    Location
    TX
    MS-Off Ver
    2013
    Posts
    38

    Re: DropDown Error Message

    Thank You very much for your continued support. I'm going to try and see if the option works. We have limited hotbuttons on our modified keyboards. Thats why having to type the word no, as silly as it might sound, puts a hold on production. I think I'm going to have to talk to the network people to see about loosening the VBA restrictions.

    I really appreciate your help. Thank You again!!

  8. #8
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,605

    Re: DropDown Error Message

    Thanks for the feedback and reputation points and good luck with your IT folks!

+ 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] Replace error message with text message
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2017, 02:37 AM
  2. Message box to display dropdown
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-10-2014, 01:57 PM
  3. An error message on open - a totally blank VBA message box
    By Mr_Tigas in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-05-2013, 11:29 AM
  4. Error Message For Function Procedure WITHOUT using a message box
    By bmr8002 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-08-2012, 02:01 PM
  5. Replacing run time error message with a different message
    By penny in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-14-2009, 10:51 AM
  6. [SOLVED] replace VBA run-time error message with custom message
    By BEEJAY in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-14-2006, 11:05 AM

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