Martin, the three videos you assembled were exceptionally helpful to me in developing this macro. Thank you very much for the time and effort you put into these.
Martin, the best VBA tutorials that I have seen. I have tried making a calendar before with no luck. Thank you for such good instructional step by step video.
Great tutorial! This has been the only VBA tutorial I have been able to follow and actually get it right! LOL What would I need to change if I wanted the calendar to pop-up when a specific cell is clicked? I tried assigning a macro to a button - which works but it the date would show up anywhere and not the cell where the date is needed. Thanks a mill! :)
Hi Martin, excellent and informative videos. Thanks! I have one request.. Is there a way of having this calendar appear when clicking any cell in a specif column? Please let me know. Thanks MIKE!!
Martin, Your problem is that it is showing the date highlighted, but you have both the background and highlight in White/very light grey. This seems to be the default setting, if you change the title back colour to another colour, I use blue, you will see the selected date in that colour.
Awesome video. But to bad it don't work for me. I tried and tried check my code about 90 times so something must be wrong with my computer or something. But awesome the way you explained it.
Well explained tutorial, and I have successfully added the Add-In to my file. One observation is that "Undo" is not working. Other than everything works like magic.
Awesome Video! Thanks so much. How could I modify the code so that if I right mouse click in a Table's Cell that the "Choose Date" appears in the commandbar for the Table? And by Table I mean an Inserted table. The right mouse click option works perfectly in a normal cell.
Hi Mark, thanks for your video. I now want to remove the addins but it still shows "insert date" on my right click. I don't know why. Could you please help?
Thank you for this very helpful tutorial Martin. I have one problem however. The "Insert Date" does not show in the right click menu if the inserted cell is part of a table. Do you know a way around this?
Thanks for the comment. I tried your suggestion of multiple months but still can't see anything. Maybe it's my setup. You have to add the statement... Me.MonthView1.Daybold(Activecell.Value)=True ... which is supposed to bold the day number you specify but it just won't do it for me!
Hi Martin, great stuff! I do have a problem, every time I open the work book I get a an additional line of inset date in the right click menu and the keyboard shortcut does not work. Can you tell me if you had such a problem and how to fix it? thank you. Alex
Martin excellent tutorial! Everything work except the caption "Insert Date" does not appear as a selection when I right click on a cell. Also is it possible to have the calendar pop up when you click on a cell? Many thanks!
Hi thank you for the video, i got a problem with the calendar, when i open the calendar always opens in the month that was created, never opens in te current month ir date.
Any ideea how can I make a pop-up calendar for events or just to keep track of my progress by selecting certain dates in different months and not write them in the selected cell?
I installed the add-in on a co-worker's machine using Excel 2010. She now gets the error "Can't find project or library." It then brings up the References - VBAProject dialog box and the checkbox "MISSING: Microsoft Windows Common Controls-2.6.0 (SP6)" is checked. I clicked OK and it then says "Could not load an object because it is not available on this machine." Any idea how to fix this? I really liked the tutorial though.
Thanks for the video. Does anyone know how I can disable certain dates in the date picker? Let`s say that I don`t want the user to pick a date earlier or later then the date I set it to???
hello i have tried and runs ok but the insert date on the commandbar does not delete and i have 3 times the same command into the bar, can you help me?
hi, thank you for the lesson. when i press (CTRL+SHIFT+C) it shows a message "Cannot run the Macro "C:/User........./'Module1.OpenCalendar' " . The macro may not be available in this workbook or all macros may be disabled" .. i tried to enable all macros by going to Macro Security and Enable all macros .. what should i do?
+nassernn I had this same error and then noticed that my Module was "module4" and not called Module1 as I had coded as I had deleted some previous tries. Not sure if the issue could be similar. So the manual marco worked but then the pick list gave me the error as that is where the coding did not match.
You can't use "Shift" as a shortcut key. If you use excel 2010 you don't need all the code for a shortcut key. You can simply select the the Macro and pick options then input your own keys. Just don't use "Shift"
Martin, the three videos you assembled were exceptionally helpful to me in developing this macro. Thank you very much for the time and effort you put into these.
Thanks very much Martin. Your instructions are clear and are delivered at a pace thats easy to follow.
Martin, the best VBA tutorials that I have seen. I have tried making a calendar before with no luck.
Thank you for such good instructional step by step video.
Hi Martin,
Great video. You explain this step by step and explain it so very clearly. Thank you
Excellent tutorial, first I found that explained the procedure from start to finish and why steps are being done - and it works!
You are the best, amazing videos
Great tutorial Martin! Very clear and informative. And finally got a tutorial that works!
Thanks for taking the time for this tutorial! It was very helpful and informative!
Very useful sir
just learned something new from a 10 year old video. I didnt even know you could password protect the code
Thanks a lot for the idea.
Outstanding
Great tutorial! This has been the only VBA tutorial I have been able to follow and actually get it right! LOL
What would I need to change if I wanted the calendar to pop-up when a specific cell is clicked? I tried assigning a macro to a button - which works but it the date would show up anywhere and not the cell where the date is needed.
Thanks a mill!
:)
Martin thanks for this, excellent stuff :-)
thank you so much for the tutorial :)
Hi Martin, excellent and informative videos. Thanks! I have one request.. Is there a way of having this calendar appear when clicking any cell in a specif column? Please let me know.
Thanks MIKE!!
Martin, Your problem is that it is showing the date highlighted, but you have both the background and highlight in White/very light grey. This seems to be the default setting, if you change the title back colour to another colour, I use blue, you will see the selected date in that colour.
Many many thanks
Awesome video. But to bad it don't work for me. I tried and tried check my code about 90 times so something must be wrong with my computer or something. But awesome the way you explained it.
Well explained tutorial, and I have successfully added the Add-In to my file. One observation is that "Undo" is not working. Other than everything works like magic.
Awesome Video! Thanks so much.
How could I modify the code so that if I right mouse click in a Table's Cell that the "Choose Date" appears in the commandbar for the Table? And by Table I mean an Inserted table. The right mouse click option works perfectly in a normal cell.
Hi Mark, thanks for your video.
I now want to remove the addins but it still shows "insert date" on my right click. I don't know why.
Could you please help?
Thank you for this very helpful tutorial Martin. I have one problem however. The "Insert Date" does not show in the right click menu if the inserted cell is part of a table. Do you know a way around this?
Awesome video! If your code doesn't work re-write it.
Thanks for the comment. I tried your suggestion of multiple months but still can't see anything. Maybe it's my setup. You have to add the statement...
Me.MonthView1.Daybold(Activecell.Value)=True
... which is supposed to bold the day number you specify but it just won't do it for me!
Hi Martin, great stuff! I do have a problem, every time I open the work book I get a an additional line of inset date in the right click menu and the keyboard shortcut does not work. Can you tell me if you had such a problem and how to fix it? thank you. Alex
Martin excellent tutorial! Everything work except the caption "Insert Date" does not appear as a selection when I right click on a cell. Also is it possible to have the calendar pop up when you click on a cell? Many thanks!
Same problem here:-(
Alaina Trott yes I want to add the calendar function when I select a cell..... had any luck ?
Thanks
Elena Razumovskaya I found a way to do it, it's a matter of selecting the clicked cell to 'open Callander'
Hi thank you for the video, i got a problem with the calendar, when i open the calendar always opens in the month that was created, never opens in te current month ir date.
Any ideea how can I make a pop-up calendar for events or just to keep track of my progress by selecting certain dates in different months and not write them in the selected cell?
Thanks a lot..:)
I installed the add-in on a co-worker's machine using Excel 2010. She now gets the error "Can't find project or library." It then brings up the References - VBAProject dialog box and the checkbox "MISSING: Microsoft Windows Common Controls-2.6.0 (SP6)" is checked. I clicked OK and it then says "Could not load an object because it is not available on this machine." Any idea how to fix this? I really liked the tutorial though.
Mark Repp have u found a way around this yet ? , thanks
i want popup calender to appear right next to the Active cell . please help on this
Thanks for the video. Does anyone know how I can disable certain dates in the date picker? Let`s say that I don`t want the user to pick a date earlier or later then the date I set it to???
hello i have tried and runs ok but the insert date on the commandbar does not delete and i have 3 times the same command into the bar, can you help me?
Will this work on another pc ?
hi, thank you for the lesson.
when i press (CTRL+SHIFT+C) it shows a message "Cannot run the Macro "C:/User........./'Module1.OpenCalendar' " . The macro may not be available in this workbook or all macros may be disabled" .. i tried to enable all macros by going to Macro Security and Enable all macros .. what should i do?
+nassernn I had this same error and then noticed that my Module was "module4" and not called Module1 as I had coded as I had deleted some previous tries. Not sure if the issue could be similar. So the manual marco worked but then the pick list gave me the error as that is where the coding did not match.
You can't use "Shift" as a shortcut key.
If you use excel 2010 you don't need all the code for a shortcut key. You can simply select the the Macro and pick options then input your own keys. Just don't use "Shift"