View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Robin Chapple Robin Chapple is offline
external usenet poster
 
Posts: 10
Default To format a cell pattern by VBA

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