Vista - Excel 2003 VB Scripting Question. How to change row color whenclicking a clickable

Good afternoon,

This may or may not be a very difficult VB Scripting or even an Excel
Feature, but if someone could help me out that would be great.

I have found out how to add clickable items to my spreadsheets.
Click on View, Toolbars and Forms
Then just click the click the item you want to add to the spreadsheet

My question is, how do you make the row change colors once you click
the box?
I want to make the row change green when the box is clicked.
I would like it to be grey when not clicked.

If possible, I would like only the row and the columns up to the
clickables to change colors,
not the entire row to the end of the sheet.

If anyone could helpp it would be much appreciated.
Thank you very much
Sgt Shayne Whitaker

usmcwhitaker wrote:hi Sgt Whitaker,

You set up a "range", and then set the color attribute of the range.

This might help:

http://techonthenet.com/excel/macros/change_color.php

Note that the notion of XL marcos and vbScript are more-or-less
interchangeable. Just about any XL macro can be re-written as
script without too much trouble.

cheers, jw
____________________________________________________________

You got questions? WE GOT ANSWERS!!! ..(but, no guarantee
the answers will be applicable to the questions)