Hi,

Sheet1 has cells c3, c4, c5, c6, c7 which contain the colors:

Blue
Red
Green
White
Pink

When the user clicks on a color, I would like to:
a. Copy that color to cell G9 in Sheet3
b. Take the user to Sheet2

How do I do that in VBA code?

Thanks,
Luther



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/