+ Reply to Thread
Results 1 to 9 of 9

Calendar Macro to insert multiple dates within the same cell

  1. #1
    Forum Contributor
    Join Date
    02-19-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    110

    Calendar Macro to insert multiple dates within the same cell

    Hello,

    Attached is what I use as a Calendar Macro and it works great for single active cell use.

    I have a column for 'Notes' and I can only use 1 cell per item so every time I have an update about a specific item I go the to notes section and put a date and leave few spaces then type in whatever the notes are. Currently I'm doing it manually and I tried to use my macro on the Notes column and what it does is to remove everything in the cell and replace it with whatever date I choose in the calendar.

    I'm trying to see if anyone can help me find a way to use my current Calendar Macro to add a date in the cell instead replacing everything in the cell with a date.

    If I didn't make a lot of sense please look to the attachment it will help clarify.

    Thank you!
    Attached Files Attached Files
    Last edited by clprdctn; 07-07-2014 at 12:03 PM.

  2. #2
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Calendar Macro to insert multiple dates within the same cell

    hi clprdctn,

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    02-19-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    110

    Re: Calendar Macro to insert multiple dates within the same cell

    Hi Watersev, I'm not sure if I explained myself properly, but I'm not sure where to put your code or if I understand it.

    Basically "column I" is where I have an issue (as seen in the attachment).

    So imagine below is all within one cell, let's say cell "I2":

    7/10/2014 Notes: Today's program was good but I have to plan better for tomorrow.
    7/11/2014 Notes: Activities were great and they were well appreciated.
    This is where I want to be able to use the 'Calendar macro' which I have inserted on top right hand side or any other macro to insert another date (as chosen from the calendar just like the calendar macro pop-up), leave 5x spaces and type "Notes:".
    But if I use it right now, it deletes everything in the cell and replaces with just a date.

    Just like the "F2" shortcut function in excel where it allows you to edit the cell instead of just replacing whatever is in the cell already.

    I guess this what I need in VBA language:
    [F2 Edit Cell]
    [Go to the last line within the cell]
    [Run Macro: OpenCalendar]
    [Leave 5x spaces]
    [Write "Notes: "]
    Last edited by clprdctn; 07-07-2014 at 11:06 AM.

  4. #4
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Calendar Macro to insert multiple dates within the same cell

    Please Login or Register  to view this content.
    amed code for calendar control, activate I2 and press Calendar button

  5. #5
    Forum Contributor
    Join Date
    02-19-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    110

    Re: Calendar Macro to insert multiple dates within the same cell

    Still no go

  6. #6
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Calendar Macro to insert multiple dates within the same cell

    please check attachment

    Select cell i3, click Calendar button, choose date, check i3 value
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    02-19-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    110

    Re: Calendar Macro to insert multiple dates within the same cell

    Thank you so much watersev, It was my mistake on applying the suggestion you sent at 11:08AM.

  8. #8
    Forum Contributor
    Join Date
    02-19-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    110

    Re: Calendar Macro to insert multiple dates within the same cell

    Quick question, is there a way to add a line to your macro to say use this format "d-mmm-yy" (which gives 7-Jul-14) for the date portion?

  9. #9
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Calendar Macro to insert multiple dates within the same cell

    Please Login or Register  to view this content.
    This would format date picked and allow to add comment at once

+ 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: 1
    Last Post: 06-14-2014, 02:01 AM
  2. Auto-populating a calendar with multiple dates
    By lamct in forum Excel General
    Replies: 2
    Last Post: 07-20-2013, 05:16 PM
  3. Choose multiple dates from Calendar
    By tone640 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-07-2012, 04:07 AM
  4. VB for Multiple dates to a calendar
    By fugro in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-23-2011, 02:08 PM
  5. How to insert a calendar to choose dates-
    By JoeMa in forum Excel General
    Replies: 2
    Last Post: 04-07-2006, 12:00 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