combos and dates

Hello
I am trying to create three combos (day, month and year) i could just
enter each day, each month and each year i want to the user to have the
options to use. However i am sure i have seen some code which only
allows the correct day to be shown depending on the month and year
selected. can anyone help with this? I would also like todays date to
be shown as the default day, month and year but have no idea how to go
about it. at the moment im just using the =now() option to get todays
date and not giving the user an option to select different.
Any help would be great! Thanks as always!
Shorty

Shorty,

You can use the Microsoft Date and Time Picker control 6.0 (sp4) in Excel
2000. It defaults to todays date and looks like a combo box. When you click
the down arrow a calendar pops up below the combo box allowing you to click
left and right buttons to go back or forward a month at a time.

You can find it in the control toolbox under the "More controls" button that
looks like a hammer and wrench with three dots underneath them.
--
Billy Rogers

Dallas,TX

Currently Using Office 2000


"Shorty" wrote:

> Hello
> I am trying to create three combos (day, month and year) i could just
> enter each day, each month and each year i want to the user to have the
> options to use. However i am sure i have seen some code which only
> allows the correct day to be shown depending on the month and year
> selected. can anyone help with this? I would also like todays date to
> be shown as the default day, month and year but have no idea how to go
> about it. at the moment im just using the =now() option to get todays
> date and not giving the user an option to select different.
> Any help would be great! Thanks as always!
> Shorty
>
>

Thanks for that, ive had a look in there but cant find the date and
time picker, is there anyway to download this option or just to insert
the VB code for it? im using excel 2000 but dont know what SP it is.
Thanks,
Shorty

found the file i need to download at:
http://support.microsoft.com/kb/297381/en-us
however once i put the Microsoft Date and Time Picker control 6.0 on
the worksheet, i cant select any information and the drop down/calendar
wont load up, any suggestions?
Shorty

quick note for the above post, the Microsoft Date and Time Picker
control 6.0 is SP6 will this make a difference?

Shorty,

I'm not sure if this is the problem, but when you place the control on the
sheet you autmatically go into design mode. In order to use the control you
need to exit design mode by clicking the icon on the control toolbox toolbar
that looks like a green triangle with a pencil. To link the control to a
cell, make sure you are in design mode and right click and select properties
and set the linked cell property to a cell address.

I'm not sure about differences with sp6.
--
Billy Rogers

Dallas,TX

Currently Using Office 2000


"Shorty" wrote:

> quick note for the above post, the Microsoft Date and Time Picker
> control 6.0 is SP6 will this make a difference?
>
>