+ Reply to Thread
Results 1 to 2 of 2

Creating a calendar in a cell for a date-picker

  1. #1
    MarkieE
    Guest

    Creating a calendar in a cell for a date-picker

    I want to give a user the ability to pick a date in a column of cells by
    using a small, drop-down calendar? Data Validation doesn't give this as an
    option-it only allows choosing dates between a range entered as free-text.

    Any help is appreciated.

    Thank you.

    Mark

  2. #2
    Bill Sharpe
    Guest

    Re: Creating a calendar in a cell for a date-picker

    You can insert a calendar control on a user form when working with
    Excel's VBA. You'll need to right click on the VBA Toolbox, select Add
    Control and scroll down to Calendar control.

    Bill

    "MarkieE" <[email protected]> wrote in message
    news:[email protected]...
    I want to give a user the ability to pick a date in a column of cells by
    using a small, drop-down calendar? Data Validation doesn't give this as
    an
    option-it only allows choosing dates between a range entered as
    free-text.

    Any help is appreciated.

    Thank you.

    Mark



+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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