Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
for my application i created a form with a textbox on it. With a code the
value of the searched cell will be displayed in the textbox. However i also want the textbox.backgroundcolor to be the same as the cell color. So something like TextBox1.backgroundcolor = ActiveCell.interior.Colorindex. Problem is that excel uses the colorindex 3 for the color red, and visual basic uses &H000000FF& for that same color. Is there a way so that i can create this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
cell backgroundcolor | Excel Programming | |||
Change backgroundcolor | Excel Discussion (Misc queries) | |||
Assigning backgroundcolor to button on form | Excel Programming | |||
HELP! I Lost The Ability To Advance From TextBox To TextBox With the ENTER Or The TAB Keys | Excel Programming | |||
Textbox Bug? Missing/delayed update of textbox filled via VBA | Excel Programming |