date picker on ThisWorkbook

Hello,

i need to have datepicker embeeded into my workbook in cells b2 c2 b3 c3 b3 c4

how can i do this?
LVL 6
FloraAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Roy CoxGroup Finance ManagerCommented:
Inbuilt datepickers can be problematic mainly because they are not always available on users' computers. Have a look at the alternatives here:

Excel DatePickers
FloraAuthor Commented:
Roy_Cox,

thanks. but the link you share is not helping me.  

i was able put up something together from the web search.

now , when you right click it shows a "Insert Date" button and when select that it will pop the datepicker which works.

how could i change this that in stead of having this via right click menu. i want to be able to double click on the cell and then the datepicker is fired up?

any help is appreciated.
EE.xlsm
Martin LissOlder than dirtCommented:
I've attached a workbook that I believe does what you want. If the "Insert Date" option is still in your right-click menu, uncomment the following line in Workbook_Open. Then close and reopen the the workbook at which time you can make the line a comment again.

Or you could just execute the line from the Immediate Window.

Application.CommandBars("Cell").Controls("Insert Date").Delete
28745177.xlsm

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Angular Fundamentals

Learn the fundamentals of Angular 2, a JavaScript framework for developing dynamic single page applications.

Roy CoxGroup Finance ManagerCommented:
Hi Martin

The MonthView control is not available in Excel 2016, certainly not in mine. I'll check with earlier versions later.
Roy CoxGroup Finance ManagerCommented:
Flora bprovide a little more information as to why it is not helping. Those examples have been used numerous times by other people.
FloraAuthor Commented:
Martin.  you are a legend

thanks very much.  your solution was perfect
FloraAuthor Commented:
Roy_Cox

i thank you for your help too.  i checked the datepicker also worked in 2016
Martin LissOlder than dirtCommented:
You're welcome and I'm glad I was able to help.

In my profile you'll find links to some articles I've written that may interest you
including these two new ones.
Creating your own Excel Formulas and doing the impossible
A Guide to Writing Understandable and Maintainable VBA Code
Marty - MVP 2009 to 2015, Experts-Exchange Top Expert Visual Basic Classic 2012 to 2014
Roy CoxGroup Finance ManagerCommented:
All the examples will work in 2016, indeed they should work in all earlier versions of Excel. Did Martin's work in 2016 because it would not work for me using 2016 because of a missing control. This issue is why I would recommend not using the ActiveX controls especially if you are sending the workbook to other users who may have different versions of Excel
FloraAuthor Commented:
thanks Roy,

yes the solution provided by Martin worked in Office 2016 Professional Plus Excel
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.