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

See Chip Pearson's page on events.

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

look at the click event of the worksheet.

--
Regards,
Tom Ogilvy


"brandim7 " wrote in message
...
I am creating a sheet and in the sheet I need a method that allows the
following.

When Cell A1 is clicked with the mouse I need it to turn black, and
when it is clicked again I need it to turn white once more. (Somewhat
like a checkbox but using fill instead of the "check". I would even be
able to insert a autoshape and have it do the click thing above if it
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 you
directly to another cell like G1 on the sheet.

If anyone could help I would really appreciate it!

Brandi


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