VBA - cell referencing

[kwinza]

Basicly what i have is a cell on my worksheet that i want to be able to type another cells address into (aka typing B3 into A1, say B3 has the number 7 in it) and then use a bit of VBA code to make a button to refer to A1 thus B3 thus 7 then add 1 to it then drop it back into B3 making B3=8 and A1=B3 eg;

Before the button was pressed;

.....A......B.....C
1...B3
2
3............7
4

After the button was pressed;

.....A......B.....C
1...B3
2
3............8
4


Note that the contense of A1 will be ever changing to different cells

Hope this is possible, cheers for any help.

[Bob Phillips]

Try

Please Login or Register  to view this content.

This is worksheet event code, which means that it needs to be
placed in the appropriate worksheet code module, not a standard
code module. To do this, right-click on the sheet tab, select
the View Code option from the menu, and paste the code in.