LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change the color of all series in an excel chart in one go. Marielle Charts and Charting in Excel 2 May 3rd 23 07:45 PM
Fill screen with chartobject by zooming? Gunnar Johansson Charts and Charting in Excel 1 December 15th 04 03:41 AM
Fill area beneath a scatter plot JZip Charts and Charting in Excel 4 December 8th 04 01:59 PM
Is there a way to change the default shading color ? greg Excel Discussion (Misc queries) 5 November 30th 04 11:40 PM


All times are GMT +1. The time now is 07:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"