Debraj
Excel Ninja
Hi Wild Gurus,
Is this possible to set TextBox Color to DataBars 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..
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..