BackColor property code
 

Hello,

Can someone please tell me what the code would be to set/change hte BackColor property of a textbox on a user form. I would like to be able to change the BackColor shade depending on other certain criteria to indicate a non-editable entry.

Thank You,

Joe Mathis

BackColor property code
 

A row would be handled like this:

With Rows(x).Interior.ColorIndex = 6

The number 6 = Yellow

Colorindex Property in VBA Help will help you with the othe
colors/numbers

-Piku

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements

BackColor property code
 

Joe,

Something like

Me.TextBox1.BackColor = RGB(123, 123, 255)

Gord Dibben also advised of this little utility to get RGB colour codes

http://no-nonsense-software.com/freeware/

RGBtoHEX 1.1a


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Joe Mathis" wrote in message
...
Hello,

Can someone please tell me what the code would be to set/change hte
BackColor property of a textbox on a user form. I would like to be able to
change the BackColor shade depending on other certain criteria to indicate a
non-editable entry.

Thank You,

Joe Mathis

BackColor property code
 

Thank you, Bob.

This woks as needed.

Joe

----- Bob Phillips wrote: -----

Joe,

Something like

Me.TextBox1.BackColor = RGB(123, 123, 255)

Gord Dibben also advised of this little utility to get RGB colour codes

http://no-nonsense-software.com/freeware/

RGBtoHEX 1.1a


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Joe Mathis" wrote in message
...
Hello,
Can someone please tell me what the code would be to set/change hte
BackColor property of a textbox on a user form. I would like to be able to
change the BackColor shade depending on other certain criteria to indicate a
non-editable entry.
Thank You,
Joe Mathis