Excel 2010 - Date Picker

**jpcsolutions** · 12-02-2011, 04:11 PM

I needed to find a way to have employees select a "Start Date" in the worksheet. I've inserted a "Date Picker" (listed as SEP Date Control in the More Controls area).

I am able to select the date when I use the form. Then I save it and close it. When I re-open the form, it doesn't save the date.

How can I allow people to choose the date, and have it populate and remain in the field?

Thanks,

**Leith Ross** · 12-02-2011, 04:52 PM

Hello jpcsolutions,

To get an answer to your question, you should post your workbook. It will save a lot of time and insure the solution works.

**jpcsolutions** · 12-02-2011, 05:05 PM

Hi Leith,

Thanks for that advice. I've posted the workbook (see attached). I've also just noticed that not only is the date reset in the Date Picker, but it resets to whatever today's date is.

Thanks again!

-Jared

**Leith Ross** · 12-02-2011, 05:12 PM

Hello Jared,

It looks like you want the user to pick a date and then save the date to the cell in column "E" (Class Start Date). Is that correct?

**jpcsolutions** · 12-02-2011, 05:14 PM

Yes, sir. That's exactly what I'm trying to do. Not sure if the Date Picker is the best way to do that though... Thoughts?

**Leith Ross** · 12-02-2011, 05:19 PM

Hello jpcsolutions,

You can use only one Date Picker to this. By using the Worksheet_SelectionChange event, you can detect if the user is in the "Class Start Date" column. The picker can then be positioned in the cell and made visible. Once the user makes the selection the date can be stored in the cell. The macro can also check if there is a date in the cell and set the picker control to that date before becoming visible.

**callsjs** · 07-18-2012, 07:08 AM

Dear Leith

Can you help me out if i have a SEP date control at sheet 1 cell "C6" and i want to capture whatever date selected in the form in sheet 2 cell "C6" what is the best way to do without coding. And if coding is required what will be the code. Request you if possible also attach the excel file the same with your explanation.

Thanks in advance

**arlu1201** · 07-18-2012, 07:13 AM

Callsjs,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.