+ Reply to Thread
Results 1 to 2 of 2

VBA assistance with pop-up calendar

  1. #1
    Registered User
    Join Date
    10-04-2013
    Location
    North Carolina, United States
    MS-Off Ver
    Excel 2007
    Posts
    56

    VBA assistance with pop-up calendar

    I've tried creating a code for a calendar to pop up in cells H6 and H10 of attached sheet. I was able to put calendars in without macros but the calednars weren't very clean looking, etc. so I've deleted code and just have a blank cell for those cells now.

    I want to be able to click on H6 and H10 and a calendar appear to select dates. Is this possible. I've seen some macros enabled sheets with a "select date" command button beside the cell and it populate the cell. I'm completely lost with writing codes for commands, etc. Any help is greatly appreciated!!

    Thanks!!
    Attached Files Attached Files
    Last edited by ExcelDummy77; 08-13-2014 at 09:46 AM.

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,177

    Re: VBA assistance with pop-up calendar

    The calendar wont appear in cells h6, but rather pop up above. You'd use a Userform with a calendar control in it. (dateTime picker)
    The Ok button would would paste the date in H6 then vanish.

+ 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. Replies: 36
    Last Post: 01-26-2017, 09:39 AM
  2. Drop-down calendar assistance
    By karmatree in forum Excel General
    Replies: 2
    Last Post: 11-04-2013, 11:14 AM
  3. Calendar functions - linking work activities with formatted dates to calendar
    By SKSS in forum Access Programming / VBA / Macros
    Replies: 1
    Last Post: 05-14-2012, 06:38 PM
  4. Calendar VBA auto filling week and month based on calendar entry.
    By perrymagic in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-18-2011, 02:00 PM
  5. Replies: 0
    Last Post: 03-27-2008, 04:36 PM

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