Thread: Calendar
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default Calendar

Hey, thanks for the correction Tyro, I completely forgot that you can do that.

Thanks...
--
Kevin Backmann


"Tyro" wrote:

VBA code is not necessary. Just right click on the calendar after inserting
it and select properties. In the LinkedCell field put the cell where you
want the date to go.

"Kevin B" wrote in message
...
You could insert either an ActiveX Calendar control or the ActiveX MS
Date
and Time picker, both of which are available off the Control Toolbox
toolbar.
Click the More Control button to see a list of ActiveX controls and select
the one you want.

However, you'll have to write some macro code to get the date information
form the calendar object to your worksheet.
--
Kevin Backmann


"Sher" wrote:

I have a spreadsheet and wanted to know is there a way to add a button
that
once clicked it opens a calendar that you can select date. I have a
start
and end date box.

Thank you.