buttons

Hi,

In the code attached to the button click event simply use

Please Login or Register  to view this content.

where A1 is the cell containing the Units. However is this the best way of proceeding? Why not just enter the unit quantity directly?

HTH

Hi,

I have built a spreadsheet to calculate costs which relate to units e.g. 1 unit=£10.

What i need is to be able to program a button so i can add 1 unit each click. Click 1 and the cell would show 1, click 2 and the cell would show 2 etc etc

Is there a way to do this?

George,

I moved Richard's post from your other thread to this thread.

Please read the Forum Rules about thread titles before starting your next thread.

thank you, i think i need to swat up on VB!

I will read the rules.