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

--
Message posted from http://www.ExcelForum.com