Printable View
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
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:
Check you setting to see which you have it set 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)
HTH