Heya
New to this site, and am new to VBA i read a dummies book so i understand how VBA works but for the life of me cant work out how to do what i want to do.
I simply want to change the background colour of a row when you click the number on the left, like how when you click it draws a box around the row, simply just "highlight" it in yellow. and if you click on another number transfer the highlight to that row and return the row back to its original state.
So to abrevate.
1. Click row number changes entire row yellow
2. If Click another row number change previous row to original colour before yellow and then change entire new row number to yellow.
3. Go back to 1.
I understand it in flow charts etc... just cant work out how to translate it into VBA code.
I think i want to simply toggle the colour of the row which is "active"
Many Thanks for your replies in advance