drop down calendar in excel cell

[CG]

Is there a way to have a drop down calendar in an excel field?

CG

 

[Earl Kiosterud]

CG,

There's an ActiveX calendar. Insert, Object, Calendar Control 10.0. If
you want to show/change a date in a cell, it has a Linked Cell property you
can point to the cell. It isn't a pop-up -- I think you'll need macro code
to make that happen.

 

[Alan]

There's an ActiveX calendar. Insert, Object, Calendar Control 10.0.
If you want to show/change a date in a cell, it has a Linked Cell
property you can point to the cell. It isn't a pop-up -- I think
you'll need macro code to make that happen.

Hi,

How can I tell whether a given control (for example, the one mentioned
above) will be available to a user:

1) Across Excel versions (97, 2000, 2002, 2003)

2) Within an excel version (2000, say) but across clients (e.g. each
user having a different configuration)

Is there any reference for this?

Thanks,

Alan.

 

[CG]

How would I do the macro code?

CG,

There's an ActiveX calendar. Insert, Object, Calendar Control 10.0. If
you want to show/change a date in a cell, it has a Linked Cell property you
can point to the cell. It isn't a pop-up -- I think you'll need macro code
to make that happen.

 

[CG]

What I really want is to have a drop down calendar and once the user select
the date have that fill the cell. Is this possible?

 

[Alan]

What I really want is to have a drop down calendar and once the user
select the date have that fill the cell. Is this possible?

Hi CG,

Try this:

1) Create new worksheet (safer to try it out)

2) Insert - Object - Calendar Control 9.0 (second from top in my Excel
2000 under Win2000 Pro)

3) Ok - It will probably sit top left of the worksheet covering A1:E12
or thereabouts.

4) Enter the VB Editor (Alt F11)

5) Select the properties of Calendar1 on Sheet1 (presumably)

6) Change the linked cell property to, say, F20

7) Exit the VBE and when you click on a date, the value of F20 will
change.


HTH,

Alan.

 

[Ron de Bruin]

Try this
http://www.rondebruin.nl/calendar.htm

 

[ste mac]

Hi CG, l may have a work book you can use... email me if you
would like a copy.. it shows a calendar on right click and will insert
the date into the active cell etc...

thunderman1..at..hotmail...com

seeya ste