#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 30
Default calendar

I have a column in my worksheet with the header of DATE. I would to be able
to click in this column, (on any cell) to bring up a calendar by month, being
able to go to preceeding month/s, or ahead month/s. Default should be the
current month. Then click on a certain date that will then be inserted into
that cell. Thanks..........
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default calendar

See Ron de Bruin's site for instructions and code for creating a dropdown
Calendar in a cell or cells.

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


Gord Dibben MS Excel MVP

On Wed, 22 Apr 2009 12:34:12 -0700, retired bill
wrote:

I have a column in my worksheet with the header of DATE. I would to be able
to click in this column, (on any cell) to bring up a calendar by month, being
able to go to preceeding month/s, or ahead month/s. Default should be the
current month. Then click on a certain date that will then be inserted into
that cell. Thanks..........


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert date from Gregorian Calendar to Hijri Calendar H.Alkhodary Excel Discussion (Misc queries) 1 February 21st 09 10:11 AM
find free sharware to include calendar pop or use calendar in cell ednc Excel Discussion (Misc queries) 2 April 14th 08 05:05 PM
how do i export excel calendar info to outlook calendar? Maggie Excel Discussion (Misc queries) 1 December 31st 07 10:27 PM
excel calendar - list of names displayed on calendar Brian'88 Excel Worksheet Functions 3 November 17th 06 10:31 PM
import calendar items from excel into outlook calendar jsewaiseh Excel Discussion (Misc queries) 0 September 2nd 05 03:53 PM


All times are GMT +1. The time now is 12:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"