Excel Color Code On Click & Redirect

[brandim7]

I am creating a sheet and in the sheet I need a method that allows th
following.

When Cell A1 is clicked with the mouse I need it to turn black, an
when it is clicked again I need it to turn white once more. (Somewha
like a checkbox but using fill instead of the "check". I would even b
able to insert a autoshape and have it do the click thing above if i
would be easier than having the cell A1 fill on click.

Also

I need a method that when you click enter on the cell B1 it directs yo
directly to another cell like G1 on the sheet.

If anyone could help I would really appreciate it!

Brand

 

[Tom Ogilvy]

See Chip Pearson's page on events.

http://www.cpearson.com/excel/events.htm

look at the click event of the worksheet.