drop down calendar in excel cell

  • Thread starter Thread starter CG
  • Start date Start date
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.
 
Earl Kiosterud said:
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.
Click to expand...

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.
 
How would I do the macro code?


Earl Kiosterud said:
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.
Click to expand...
 
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?
 
CG said:
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?
Click to expand...

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.
 
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
 
Back
Top