+ Reply to Thread
Results 1 to 6 of 6

Disable Validation Drop Menu?

  1. #1
    Forum Contributor
    Join Date
    01-18-2013
    Location
    England
    MS-Off Ver
    2016 (Mac)
    Posts
    149

    Disable Validation Drop Menu?

    Hello Everyone,
    I have a validation drop menu that I want to disable when one date is greater than another date. So for example today is 7th November but I want the drop menu to disable on 8th November. There is some lines of code in the sheet as follows:

    Please Login or Register  to view this content.
    This code just calls macros that are run whenever a day is selected, so if 5 is selected from the drop menu then case 5 is called an a macro run named DayFive.
    The drop menu is in cell C6 (FYI!). The source within the Data Validation settings is 1,2,3,4,5, So the drop menu just drops down a list of 5 numbers.

    I hope that this is the necessary amount of information needed for a solution? I have tried using if statements but am not very good at Excel (at all!).

    Thank you very much in advance for any help,

    Regards,

    Margate
    Last edited by Margate; 11-08-2013 at 03:41 PM. Reason: Initial post did not make sense!

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Disable Validation Drop Menu?

    I'm sorry, maybe I'm not fully understanding your first statement. Disable when what two dates are the same? Disable on Dec 8th why? What other dates will disable?
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

  3. #3
    Forum Contributor
    Join Date
    01-18-2013
    Location
    England
    MS-Off Ver
    2016 (Mac)
    Posts
    149

    Re: Disable Validation Drop Menu?

    Hello Solus,
    Ok so the start date on my sheet is lets say today's date 8th November. When the day expires and it becomes the 9th November I want the drop menu to auto disable if that is possible?

    Also your completely right! The dates in the initial post were totally wrong! I will try and edit it so it makes sense!

    Thank you for your help,

    Regards,

    Margate

  4. #4
    Forum Contributor
    Join Date
    01-18-2013
    Location
    England
    MS-Off Ver
    2016 (Mac)
    Posts
    149

    Re: Disable Validation Drop Menu?

    Hello Solus,
    Ok so the start date on my sheet is lets say today's date 8th November. When the day expires and it becomes the 9th November I want the drop menu to auto disable if that is possible?

    Also your completely right! The dates in the initial post were totally wrong! I will try and edit it so it makes sense!

    Thank you for your help,

    Regards,

    Margate

  5. #5
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Disable Validation Drop Menu?

    Can you attach your workbook? It may put things in context.

  6. #6
    Forum Contributor
    Join Date
    01-18-2013
    Location
    England
    MS-Off Ver
    2016 (Mac)
    Posts
    149

    Re: Disable Validation Drop Menu?

    Hello Solus Rankin,

    I would do but I am unable to upload because I am on a works computer! I would do it at home but I am on a cruise ship!

+ 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. Data Validation from drop down menu
    By ciapul12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-01-2011, 04:18 PM
  2. Replies: 2
    Last Post: 01-13-2010, 09:31 PM
  3. Data Validation for Drop Down Menu?
    By typektunus in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-25-2009, 04:42 PM
  4. [SOLVED] Disable custom drop-down menu
    By Piers 2k in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-16-2006, 04:50 AM
  5. Validation- Drop Down menu size
    By bras1l in forum Excel General
    Replies: 2
    Last Post: 02-03-2006, 12:19 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