How to insert date using a pop up calendar control in a cell in E.

S

sinned81

It has to be simple to add a control to an excel worksheet so when a user
clicks on a cell a calendar pops up allowing the selection of a date.

I just can't figure out how to do it.
 
I

Iain the scout

Ist it possible to link the date reurned from the calender into a formula in
another cell to perform date maths. If so how can I do it?
 
B

blair

hi.. under more controls, i do not have a selection called "microsoft date
time picker".. i am using excell ver 2003
 
K

Ken Macksey

The ms datepicker is part of the ms common controls ocx (MSCOMCT2.OCX)
usually found in the windows\system or windows\system32 folder.

Ken
 
P

Pierre

Hi Ken,

is it possible to get these controls ? I did a search and I get the
impression you need Visual Basic. I simply would like to have these controls
to use in Excel.

thank you

Pierre
 
S

Sunnyskies

Thats great for a start date, but now I also want an end date to be inputted
into another cell
 
Top