I put a spinner from the Forms toolbar on a worksheet.
I rightclicked on it and chose Format control|Control tab and used A1 as the
linked cell.
I also made the spinner spin from 1 to 7.
Then in B1, I put this formula:
=TEXT(A1,"ddd")
I'm using A1 as a date (1 = Jan 1, 1900, which was a Sunday).
tina wrote:
Hi
Does the value in spinbutton properties have to be numeric or can it be a
day eg mon tues wed etc if so how do I dio this
Thanks
tina
--
Dave Peterson
|