Need Pop-up date picker calendar for Excel

Topic

New Reply

Hi,

I have an excel spreadsheet that I send to several employees every week to update. I was wondering if there was some way to add a calendar pop-up when I click on my column Start Date and End Date? I know I can format the cells to be a “date” but that wouldn’t be any fun. How else do we learn new things…
Does anyone have any ideas how I can add a calendar to pick a date from? My Start Date column is B2 and End Date is C2. I also need something that is available on the workbook and doesn’t require my users to download any add ins.

Much appreciated!

Reply | Quote

Replies

Does this do what you want?

Reply | Quote

Does this do what you want?

Hi, I don’t see anything attached. Thank you.

Reply | Quote

Hi, I don’t see anything attached. Thank you.

There was nothing attached. The word this in my previous post is a hyperlink. (It is blue)

Reply | Quote

I created my own calendar control a while back. I had been using mscal.ocx, but then for a number of users the file was getting deleted by a corporate IT logon script.
I should confess that I copied the idea from somebody else (e.g., using command buttons for each day), but I tidied it up a lot.

I have it initiated by a command button, but you could use a Worksheet_SelectionChange event if you’d rather.

Reply | Quote

I created my own calendar control a while back. I had been using mscal.ocx, but then for a number of users the file was getting deleted by a corporate IT logon script.
I should confess that I copied the idea from somebody else (e.g., using command buttons for each day), but I tidied it up a lot.

I have it initiated by a command button, but you could use a Worksheet_SelectionChange event if you’d rather.

Wow nice calendar! Is there a way to select a date from the calendar and it fill in the date in my column called start date?

Reply | Quote

Thank you!

Reply | Quote