command button count won't add in the correct cell, based on combobox selection.

Hi

I am using a command button to count the number of clicks made. However I need to be able to select the cell in which to add, based on the selection of a combo box.

eg

If combobox linked cell =1, then I need to add +1 to Cell A1 when the command button is pressed.

But if the value of combobox linked cell is 2, then I need to add +1 to cell A2


So it's like I need to be able to offset the cell in which to add, by the value of the combobox.

It gets much more convoluted than that, but if anyone can give me the basic principle, I would appreciate it!

Thanks Tigeravatar

It works a treat...Took a little while to get my head around it, but I'm there now!