In Office 2010 they have replaced the date picker with an updated version in the Active-X library, called MSCOMCT2.OCX. He wonders how he can load this tool into Excel 2010 and Excel 2013.Īccording to reports from Microsoft, the traditional date picker tool (called MSCAL.OCX) was shipped with Office 2007, but is not included in later versions of Office. One has Excel 2010 with the Date Picker tool but the other two, one with Excel 2010 and one with Excel 2013, do not have this tool available. Looking forward for your comments.Ed has three computers at work. Let me know if you have some better solution. 'Enabling the Date picker pop-up on the particular column Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) I want to call this function whenever I click “B2:B20” cell. MsgBox "Sorry the Date Picker add-in is not open."Īpplication.Run "'"
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |