I am designing a spreadsheet and I want to be able by the use of a drop down
box be able to chose dates. This is to allow the user to be able to look at
a glance and see say three weeks fromtoday without having to resort to
looking up in diary etc. It is the same as when you see a similat thing if
you book flights on line. They show a little calandar and you move pointer
across to click on the date/dates you want.

I have looked all over web and cannot find a resoloution! ANY help most
welcome

You missed a few places in your search all over the web.

See how Ron de Bruin does it.

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

Note the "more information" link to download mscal.ocx if needed.


Gord Dibben MS Excel MVP

On Thu, 5 Jul 2007 14:52:01 -0700, Sioux
wrote:

I am designing a spreadsheet and I want to be able by the use of a drop down
box be able to chose dates. This is to allow the user to be able to look at
a glance and see say three weeks fromtoday without having to resort to
looking up in diary etc. It is the same as when you see a similat thing if
you book flights on line. They show a little calandar and you move pointer
across to click on the date/dates you want.

I have looked all over web and cannot find a resoloution! ANY help most
welcome

On Jul 5, 5:52 pm, Sioux wrote:
I am designing a spreadsheet and I want to be able by the use of a drop down
box be able to chose dates. This is to allow the user to be able to look at
a glance and see say three weeks fromtoday without having to resort to
looking up in diary etc. It is the same as when you see a similat thing if
you book flights on line. They show a little calandar and you move pointer
across to click on the date/dates you want.

I have looked all over web and cannot find a resoloution! ANY help most
welcome

If you need a more robust solution, check out http://www.wincalendar.com/excel-calendar.html
.... with this you can pick a date by simply right-clicking on any
existing date. Wincalendar even 'snaps' the the default date value.

regards
Sam