+ Reply to Thread
Results 1 to 6 of 6

Applying Date Controls with data validation when using a Date Picker

  1. #1
    Registered User
    Join Date
    02-16-2013
    Location
    Cape Town, South Africa
    MS-Off Ver
    Excel 2010
    Posts
    24

    Applying Date Controls with data validation when using a Date Picker

    Dear All

    I am using a VBA created user form as a date picker in my workbook that works perfectly. However I would appreciate any assistance in overcoming a small challenge?

    I need to validate a date entry cell, C30 (selected using the date picker) to only allow date entries greater than or equal to TODAY'S date.

    Cell C6 contains formula =Today() and cell C30 is the date entry cell (using the date picker). Data Validation setting for cell C30 is: Allow = Custom, Data = greater than or equal to, Start date =C6.

    But when I select a date earlier than the start date the in C30 it is still accepted.

    Please help?

    Thanks, Peter

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Applying Date Controls with data validation when using a Date Picker

    Any chance you could upload a sample workbook?

    Click on GO ADVANCED and use the paperclip icon to open the upload window.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    02-16-2013
    Location
    Cape Town, South Africa
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: Applying Date Controls with data validation when using a Date Picker

    Am I blonde? Clicking the paper clip icon does nothing, must I activate the attachment facility somehow?

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Applying Date Controls with data validation when using a Date Picker

    I think there's been some sort of problem with attachments.

    Try scrolling down below the message window and clicking Manage Attachments under Attachments in the Additional Options section.

  5. #5
    Registered User
    Join Date
    02-16-2013
    Location
    Cape Town, South Africa
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: Applying Date Controls with data validation when using a Date Picker

    I seem to have no luck doing this as well, it shows that the file has been uploaded but when I close the window the attachment does not appear in my message.
    Could I email the file to you?
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    02-16-2013
    Location
    Cape Town, South Africa
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: Applying Date Controls with data validation when using a Date Picker

    Sorry I see it has been attached!

+ 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. Date picker used to populate text box. Date changes back to original value on opening.
    By Stratfordoaks in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-07-2016, 09:42 AM
  2. Replies: 0
    Last Post: 11-23-2015, 04:50 AM
  3. Replies: 0
    Last Post: 08-01-2015, 12:29 AM
  4. Replies: 1
    Last Post: 06-14-2013, 08:39 AM
  5. Add Date Picker to additional controls Excel 2010
    By rvc81 in forum Excel General
    Replies: 5
    Last Post: 09-29-2012, 01:13 AM
  6. Replies: 0
    Last Post: 06-21-2012, 02:24 PM
  7. Re-registering date and time picker controls
    By matpj in forum Excel General
    Replies: 1
    Last Post: 06-27-2007, 08:32 AM

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