• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

TextBox1.BackColor = Range(RefEdit1).DisplayFormat.Interior.Color

Debraj

Debraj

Excel Ninja
Hi Wild Gurus,

Is this possible to set TextBox Color to DataBars Color..


Code: 
TextBox1.BackColor = Range(RefEdit1).DisplayFormat.Interior.Color


Title code works well in case of Normal Conditional Formatting or Color Scales Conditional Formatting, but it will highly appreciable, if DataBars Formatting also adapted in a UserForm's any Control..


* How does DataBars Created.. are they something like ProgressBar..
 
Debraj


Linking to CF colors isn't simple


I'd suggest replicating the logic for the CF's in your UDF and using that to color the Textbox


If your serious about using CF colors have a read here: http://www.cpearson.com/excel/CFColors.htm
 
You must log in or register to reply here.
Back
Top