CommandButton Programming

[Cmat]

Hi there,

First of all I have no idea on programming. I need to create a command button on a worksheet in order to add and remove a price from a cell when I click on it. Is this possible to be done?

[ChemistB]

Yes, it would be. There isn't enough information here to figure it out though. Would this be a specific cell, a selected cell, last occupied cell in a particular column.....?

ChemistB

[Cmat]

Thanx for your reply Chemist,

that would be a specific cell e.g when you click on the button to copy the price from cell D23 and paste it to cell E23 and by clicking again to remove the price if it is already in cell E23