calendars

  • Thread starter Thread starter gary kropp
  • Start date Start date
G

gary kropp

Can anyone tell me how to link a dropdown calendar to a
cell in an excel spreadsheet. I need it to return a
selected date from calendar to cell.
 
Can anyone tell me how to link a dropdown calendar to a
cell in an excel spreadsheet. I need it to return a
selected date from calendar to cell.
Click to expand...

#1
Using the "Control ToolBox" toolbar, you should be able to place a Calendar
control on your worksheet (via the "More Controls" button). Once it's on
there, you can use the "Properties" button to set its "Linked Cell" prop to
e.g. "Sheet1!A1". But I dunno if this'll count as a "dropdown calendar" (?)

#2
"=TODAY()" in A8 ; "=A8-1" in A7, drag this up to A1. "=A8+1" in A9, drag
this down to A14.

Then for *the* cell, use A1:A14 as the source for a data validation list.

HTH,
Andy
 
Back
Top