MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Spinner Control


Posted by Little Dave on April 10, 2001 2:27 PM

how do i get a spinner to increment time which is in a cell in Microsoft Excel 95?

I need the spinner to increment a standard 00:00:00 time format by five minutes (00:05:00).


Posted by Brian M. on April 11, 2001 12:10 AM

In the control properties box leave as default.
e.g. Cell link to B1. Format cell A1 hours mins secs, in cell A1 =B1/288