Date Time Picker Size Out In Excel

[jawwadaq]

Hi;
When i insert date and time Picker control in the excel i set the width=75 and hight 17.25.But when i run it or save the excel file and when open it again and run it shows a big combo ,all its size become very big.Its alignment is out.i have tried office xp 2002 and 2003 professional edition but it does not work

[RobDog888]

Welcome to the Forums.

Right click on the dtp in design mode. Click Format Control...
In the Size tab you can set the sizes. Also, in the Properties tab
you can set the control to:

• Move and size with cells (will adjust control to cell's width as user resizes columns)
• Move but dont size with cells (self explanitory)
• Dont move or size with cells (self explanitory)

Check you setting to see which you have it set to.

HTH