Hello,

I am trying to write the VB code to do the following,

1. Change the colour of the subsequent rows to green each time the command button is clicked. For Example, once the button is clicked, row with cells A1, B1 & C1 should turn green. Next time the button is clicked rows with cells A2, B2 & C2 should turn green. Similarly, on the third click on the button, third row with cells A3, B3 & C3 should turn green & so on.

2. Change the colour of the cell say A1 to red when the command button is clicked. Next time when the same button is cliked, cell A2 should turn red but the cell A1 should turn white. Similarly, when the same button is clicked the third time, cell A3 should turn red but cells A1 & A2 should turn white. On the fourth click to button, cell A4 should turn red while cells A1, A2 & A3 should turn white.

I hope I am able to explain my questions.

Thanks for the help!