increasing/deceasing macro

[chobanne]

Hi all

I have a problem i can't handle.

Example i have a cell A1 in which i have typed value like 3. I need a macro who will, with every click on it, increase value in cell A1 for 0.1 step, like 3 clikc 3.1 click 3.2 click 3.3 etc... I think u figure what i mean. I need the same macro for decreasing like 3 click 2.9 click 2.8 etc. help please...

thank you

 

[Ruddles]

Sorry, I didn't think: the increment on the Form Spin control has to be an integer. Stupid Microsoft!

You could link it to a cell somewhere out of sight like ZZ1, set the increment to 1 and then display =ZZ1/10 in the cell. (If you made the spin control large enough, you could use the cell behind it.)

Or you could use the ActiveX Spin control and use the SpinUp and SpinDown events to change the cell by whatever increment you wanted.

 

[chobanne]

thank you it was helpfull