View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default In excel, I want a drop down box to a calandar to choose dates

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