Why do you need VBA? Why don't you instead use Conditional Formatting?
Format--Conditional Formatting.
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"Robin Chapple" wrote in message
...
I have a worksheet that records attendance with code that enters
"Present" when double clicked.

Can I have VBA code to format the pattern to a colour?

Thanks for your help,

Robin Chapple