A Forms toolbar spinner control returns an integer. You can have another
cell with a formula that references the cell linked to the spinner like
=CHOOSE(A1,"Sun","Mon","Tues","Weds","Thurs","Fri" ,"Sat")

Here A1 is linked to the spinner. You'd want to limit the spinner's minimum
value to 1 and maximum value to 7 in this case.

--
Jim Rech
Excel MVP
"tina" wrote in message
...
| 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