Date picker within each cell?

Good afternoon all!

I am trying to find a way to create a date picker to appear in a cell similar to a drop down list. I want to make it so each cell in the column has its own date picker to allow for employees to select varying dates easily. So far from looking around myself, I can only find a way to make a date picker that isnt within a cell and has to be linked for a date to appear. The downfall being that I would have to make a separate date picker and link to each and every cell.

Does anyone know of any way to achieve this?

Any help is greatly appreciated!

Try this:-
This code will give you a "Calendar" drop down list for any cell selected in column "A".
The dates run from Today +-30 days.

Please Login or Register  to view this content.

Originally Posted by MickG

Try this:-
This code will give you a "Calendar" drop down list for any cell selected in column "A".
The dates run from Today +-30 days.

Please Login or Register  to view this content.

Hi MikeG! Thanks you for your assistance! The code you provided works wonderfully with getting the picker to appear in each individual cell I need to change the method of input however. My apologies for not being clearer to begin with.

I have attached an example of the style of date picker that I need to create. It is the picker that I was able to get from using the ActiveX input method, but I need an individual one for each cell in a certain range. I am needing this style due to the fact that some of the users have very minimal experience with excel and I am trying to make it as user friendly as possible, and because some of the dates that need to be entered can range a few years apart.

How would I create one like that?

33nw8xe.png

Originally Posted by jaslake

Hi loccy

Take a look at this link...if it works for you and you need help adapting let me know.

http://www.excelforum.com/excel-prog...-calendar.html

Nothing seems to happen in that workbook for me. There is code there, but I can't seem to make it have any effect?

Originally Posted by jaslake

Hi loccy

Open the Workbook in Post #2. Enable Macros. Click on any cell in Column A.

I made sure I had macros enabled, but still no effect. When opening the code and clicking the play button I get the attached error.

293k9cj.png

From what I saw behind the error, I don't think it will meet what I've been requested to do.

My boss says he needs it to behave like a drop down list would, but with a calendar in lieu of the list, if that helps to make it clearer. With the calender's GUI looking pretty much as an ActiveX control date picker would.

Originally Posted by jaslake

Hi loccy

Can't see png files...if you must attach pictures attach jpg.

What does this mean...there is no "Play Button"?

Sorry, should have been clearer. It was the 'Run Macro' button on the VBA window.

Originally Posted by jaslake

Hi loccy

Here's the File. Click on any cell in Column A...you'll get a Date Picker.

Ah working now

Is there any way to make something like that drop down from a cell when its selected?

This is how it is appearing when I use it;

w9wnr6.jpg

But this is what has been asked of me (they gave me this image when giving me the job);
CalendarPopupCss.gif

Is that something that can be created in excel, without too many complications? I can try to convince them that your method is fine

Hi all,
How can I get this to appear in multiple columns. For example, column two, and column 6?

Thanks

Dear Jaslake
i have one question
i found this code in your post link

HTML Code: 

my question how can i make it suitable for multi column, suppose Column A, C , D, G, I, AF,AE ,AW and soon