ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Calendar on drop down (https://www.excelbanter.com/excel-discussion-misc-queries/102424-calendar-drop-down.html)

rexmann

Calendar on drop down
 
Hi all

not sure if this is possible without programming but thought I would ask! In
excel (im running excel XP), I want to create a cell that when you click on
it a calendar appears and the user can select a date. Is this possible (I'm
up against a tight time schedule).

Any advice (even if it's to say "No you can't!!!") appreciated

Kind regards

Rexmann

Gord Dibben

Calendar on drop down
 
Not possible without programming.

If you do decide you will use programming, Ron de Bruin has code.

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


Gord Dibben MS Excel MVP


On Tue, 1 Aug 2006 04:55:02 -0700, rexmann
wrote:

Hi all

not sure if this is possible without programming but thought I would ask! In
excel (im running excel XP), I want to create a cell that when you click on
it a calendar appears and the user can select a date. Is this possible (I'm
up against a tight time schedule).

Any advice (even if it's to say "No you can't!!!") appreciated

Kind regards

Rexmann



rexmann

Calendar on drop down
 
Hi Gord

Nice one - that should do it

Cheers Rexmann

"Gord Dibben" wrote:

Not possible without programming.

If you do decide you will use programming, Ron de Bruin has code.

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


Gord Dibben MS Excel MVP


On Tue, 1 Aug 2006 04:55:02 -0700, rexmann
wrote:

Hi all

not sure if this is possible without programming but thought I would ask! In
excel (im running excel XP), I want to create a cell that when you click on
it a calendar appears and the user can select a date. Is this possible (I'm
up against a tight time schedule).

Any advice (even if it's to say "No you can't!!!") appreciated

Kind regards

Rexmann





All times are GMT +1. The time now is 07:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com