http://support.microsoft.com/default...b;en-us;161517
XL97: Visual Basic Example for Using SpinButton with a Date

http://support.microsoft.com/default...b;en-us;213224
XL2000: Visual Basic Example for Using a Spin Button with a Date

http://support.microsoft.com/default...b;en-us;161816
XL97: Min Can Exceed Max on ScrollBar or SpinButton Control


--
Regards,
Tom Ogilvy


Pal wrote in message
news:jQaXa.40079$cF.13520@rwcrnsc53...
How can I used the Spin Button to increment or decrement the date in cell
A1
format(dd/mm/yyyy)
I went thru the help but I could not find the location to change the
spinup
and spindown properties.
Thanks
Pal