Date Picker for Mac Excel 2016

Question

Hi all

FYI

I upload the second version of the Date Picker Add-in with a new option to close the form automatic after you insert a Date.

And I open the Date Picker not vbModeless anymore in this version because the Excel team not seems to be able to fix the bugs that there are when you open userforms vbModeless in Excel 2016.

http://www.rondebruin.nl/mac/addins/datepicker.htm

Please report problems if you have them.

Answer 1

Whatever the issue was evidently it has cleared up. Thanks for getting back with me. 

_________

Disclaimer:

The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone and do not reflect upon my position as a Community Moderator.

Answer 2

Good morning, Please read the instructions, you open the date picker by rightclicking on a cell and using the menu item in the cell menu

Answer 3

I've downloaded and installed version 2. I use 15.29.1 Excel and Version one seems to work better for me Double clicking in the cell doesn't bring up the Date Picker. To bring up the date picker first the column or Row has to be formatted as date first. Then you click within the cell and to bring up the Date Picker you right click or control click in the cell. Then and only then you can choose the Date Picker. Then the Column remain Highlighted.  On Previous version (version 1) I could double-click within a cell, and the Date Picker will appear. And after you click in a new column or row the Column or Row become inactive as it should.  I have another Date Picker that I use in Excel2011 that works perfect in 2011. And works the way it should so far as activating it and it releasing its hold when finished. You enter a Cell Double click in the cell up pops the date Picker. Once a day is picked, the picker releases its grip and you can actually double click again in the next cell and same happens.   Now if I try it in 2016 it activates with a double click but if I click cancel it throws up an error message.

Specs for my machine:

_________

Disclaimer:

The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone and do not reflect upon my position as a Community Moderator.