Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pal Pal is offline
external usenet poster
 
Posts: 27
Default Spin Button to increment or decrement the date in cell A1

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



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Spin Button to increment or decrement the date in cell A1

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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing Cell Link on Spin Button Form Control Adam Ronalds Excel Discussion (Misc queries) 14 August 27th 09 05:52 PM
cell math to decrement/increment a cell BUFFETT Excel Worksheet Functions 1 June 16th 06 08:37 PM
spin button value tina Excel Discussion (Misc queries) 2 March 17th 05 02:11 PM
Set Increment on Spin Button to 0.1 Mark Excel Discussion (Misc queries) 1 March 14th 05 11:22 AM
How do I increment or decrement values in a column? OldKenGoat New Users to Excel 3 January 6th 05 01:05 AM


All times are GMT +1. The time now is 05:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"