Results 1 to 3 of 3

Date Combo Boxes

This is a discussion on Date Combo Boxes within the Excel Questions forums, part of the Question Forums category; I'm attempting to build a spreadsheet that will have approximately 20 dates inputted over a course of a month. IS ...

  1. #1
    New Member
    Join Date
    Jul 2002
    Posts
    3

    Default

    I'm attempting to build a spreadsheet that will have approximately 20 dates inputted over a course of a month. IS there an easy way to build a combo box that when clicked will open up a calender for easy access to the current date? Or can something else be done for a single click to input dates rather then have to type in each date. Any help appreciated.

    Brad

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701

    Default

    You can use Data Validation|List.

    _________________
    Hope this helps.
    Kind regards,

    AL CHARA

    [ This Message was edited by: Al Chara on 2002-07-24 12:17 ]

  3. #3
    Board Regular
    Join Date
    Jun 2002
    Posts
    119

    Default

    Open the control toobox and select the more controls button (looks like a hammer and wrench symbol). From this list choose Calendar Control and then "draw" the calendar on your sheet. When you get the calendar on your sheet, right click it and select view code. Then enter this code.

    Private Sub Calendar1_Click()
    ActiveCell.Value = Calendar1.Value
    End Sub

    Now when you click on the calendar, that date will go to whatever cell is selected.

    Dave

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com