I want my drop down calendar to work when I click in any cell in a specified column

I am currently using a pop up calendar in Excel 2010 that with CTL+SHIFT+B that a calendar pops up, you select your date, and then the calendar closes. What I now need is to write a code or formula or something that when I click in any cell in column F lets say that the calendar opens automatically in that cell and then still close automatically after the date selection is made.

Hi dnoteman,

Please refer below the link, hope this helps.....

http://www.fontstuff.com/vba/vbatut07.htm

Do Add Reputation by clicking the star at left bottom. If my reply helped you.

i'm a bit delayed in my response but this link covers how I am already using the pop up calendar with a key board command of ctrl+shift+B. I want the user to click on any cell in column F lets say and have that calendar appear like a drop down list would.

Something like this;

Please Login or Register  to view this content.