+ Reply to Thread
Results 1 to 6 of 6

Pop Up Calendar VBA Code Help

  1. #1
    Registered User
    Join Date
    09-30-2015
    Location
    United States
    MS-Off Ver
    2007
    Posts
    37

    Pop Up Calendar VBA Code Help

    I have created a pop up calendar using VBA.

    I have two cells that require calendar input. The dates selected will be different from each other.

    In each of the cells I have placed a calendar icon and programmed a macro to open the pop up calendar.

    Question is: How to I make sure that when the user clicks on one of the icons that opens the pop up calendar that the selected date will populate in that specific cell? When the user moved to the next cell that needs calendar date input, should I assign the same macro to that icon?...bringing up the same pop up calendar? Will I be able to then have that specific cell filled in the with the selected date?

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Pop Up Calendar VBA Code Help

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need.
    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

  3. #3
    Registered User
    Join Date
    09-30-2015
    Location
    United States
    MS-Off Ver
    2007
    Posts
    37

    Re: Pop Up Calendar VBA Code Help

    F-0068 08SEP2015.xlsm

    The project is attached.

  4. #4
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Pop Up Calendar VBA Code Help

    Here's the code that I changed and the workbook if you want to try it out.
    If you need any other help, just ask.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    09-30-2015
    Location
    United States
    MS-Off Ver
    2007
    Posts
    37

    Re: Pop Up Calendar VBA Code Help

    Works perfectly...thank you very much!

  6. #6
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Pop Up Calendar VBA Code Help

    Please click the Thread Tools drop down box above your first post and choose solved.

+ 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. Please help me to modify that code for build in calendar...
    By erkamu in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-05-2014, 09:36 AM
  2. Calendar code??
    By Laura Marie in forum Excel General
    Replies: 5
    Last Post: 06-03-2013, 03:37 PM
  3. [SOLVED] VBA code - calendar for multiple cells
    By Long_Boy35 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-22-2013, 10:25 AM
  4. Calendar macro - debugging some old code
    By Black Monday in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-27-2011, 07:25 PM
  5. What is best way to code calendar pop-up in Excel
    By cmwilbur in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-01-2010, 05:42 AM
  6. Embedded calendar VBA code...
    By levo_redkid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-04-2008, 01:05 PM
  7. Calendar code
    By julvaz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-20-2007, 02:17 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