Calender Control

Hello

I am designing a form usins Excel and would like to have an option where you can have a caleder pop up to select a date.

I would also like to do the same for the time of day

Thanks

Depending on the version of Excel you have, you can use the Date and Time picker.
1. Go to View in the main toolbar.
2. Go to Toolbars-Control Toolbox
3. The last option in the toolbox (it should look like a hammer) is the "More Control" option. Select that.
4. Scroll down to the Microsoft Date and Time Picker Control 6.0 (SP4) and select it.
5. Draw a combo box that will serve as your calendar control.
6. In the control toolbox, select the first icon (it should look like a green triangle)
7. Click on the arrow in the date box, and a calendar will pop up.

Let me know if that help.s

I tried this but My controls did not have microsoft date and time picker.

What version of Excel do you have?

version 2003

Hi Bhavini,

I am using 2003 and have it under more controls.

you probably need to do a custom - full installation to see if it appears.

Cheers,

Originally Posted by Bhavini

version 2003