STILL NOT THERE - Spin Decimal - NOT INTERGERS

[tanyagi]

Hi,

Can someone HELP!!! We're trying to get a spin button to increase a cell by 0.01 however it will only allow an interger eg 1, 2 etc. How can we fix this so we can either have a figure override the spin button (or use it) and get it to create .00 values. Fixed decimals seem to work but then mess every other value up..... HELP
This message was edited by tanyagi on 2002-05-05 09:10

 

[tanyagi]

Cheers Tom.

Found another way round, had been linking the properties to the cell ref, then entering the code. However, by creating the button, entering the code you gave, then giving a name to the button, IT WORKED. Many Thanks for you Help, everyone was impressed by your solution.

Tanya