View Single Post
  #1   Report Post  
Steve Conary
 
Posts: n/a
Default Identifying the Active Fill Color

I have a routine that adds a shape to a selected cell and I would like
to have the color of that shape be the last selected "fill" color (or
the default fill color if no change made since Excel was started). How
can I determine the active fill color from the "Fill Color" toolbar
using VBA? Seems like there should be a way to get that color value.
Thanks...
Steve