Thread: Fill Color
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default Fill Color

something like this could be run by a shortcut key........

Sub pwz()

ActiveCell.Offset(0, 1).Interior.Color = vbRed

End sub


this fills the cell one cell to the right from the active
cell............
hope it gets you started.
:)
susan


On Jun 24, 10:12*am, "pwz" wrote:
Any scripts can call out the Fill Color by a customized shortcut key? *It
will be excellent if it can be popped up nearby the active cell. *Thanks in
advance for any help!

Pat