Hi,
I'm following this post to create an interactive calendar: http://chandoo.org/wp/2013/04/09/how...ents-tutorial/
The issue that I'm facing is steps 4 and 5 - I'm not able to get the macro to work. I followed the instructions for steps 4 and 5, but when I click on a calendar date, the date doesn't show in the assigned cell for selectedCell. How do I get this part to work so I can eventually pull data from the selectedCell as shown in the tutorial?
I looked at the tutorial and was able to delete unnecessary information so only the required information remains. The Excel can be found here: http://www.filedropper.com/mastercla...ctive-calendar
In the file, if you click on dates within the calendar range, the highlighted yellow cell (selectedCell) would return the date selected. I'm unable to get that on my own file: http://www.filedropper.com/mysample
Can someone please explain to me what I'm doing incorrectly and how to fix it? Thanks!
I'm following this post to create an interactive calendar: http://chandoo.org/wp/2013/04/09/how...ents-tutorial/
The issue that I'm facing is steps 4 and 5 - I'm not able to get the macro to work. I followed the instructions for steps 4 and 5, but when I click on a calendar date, the date doesn't show in the assigned cell for selectedCell. How do I get this part to work so I can eventually pull data from the selectedCell as shown in the tutorial?
I looked at the tutorial and was able to delete unnecessary information so only the required information remains. The Excel can be found here: http://www.filedropper.com/mastercla...ctive-calendar
In the file, if you click on dates within the calendar range, the highlighted yellow cell (selectedCell) would return the date selected. I'm unable to get that on my own file: http://www.filedropper.com/mysample
Can someone please explain to me what I'm doing incorrectly and how to fix it? Thanks!