Home |
Search |
Today's Posts |
#1
|
|||
|
|||
spin button value
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set Increment on Spin Button to 0.1 | Excel Discussion (Misc queries) | |||
Command Button VBA code | Excel Discussion (Misc queries) | |||
How to assign a macro to a commnd button | Excel Discussion (Misc queries) | |||
command button moves | Excel Discussion (Misc queries) | |||
How do I setup a spin button in excel | Excel Discussion (Misc queries) |