Thanks for the compliments regarding my calendar.
Unfortunately, I can't get your's working on Excel 2010 64 bit. It opens but when I click on the Insert tab the following procedures generates a Type Mismatch error:
Code:
Sub GetLabelMonth(control As IRibbonControl, ByRef returnedVal)
'So everybody who knows the MonthName fuction will know what this does. Those who don't just hit F1
returnedVal = MonthName(lngSelectedMonth, True)
End Sub
With "lngSelectedMonth" highlighted as the culprit. I'm not all that experienced with Excel 2010/64 bit, but I'm aware of the use of "#If VBA7 Then" to define variables for 64 bit vs 32 bit. It looks like despite having Win 7 64bit and Excel 2010 64bit, anywhere "lngSelectedMonth" or "lngSelectedYear" is used, the
functions are still expecting a Long not LongPtr and wrapping them in Clng seems to fix the issue, but I'm not sure if that is just for my version/set up. Not sure it would work for anyone else.
Bookmarks