how to give textboxes the same interior color?

**impartrudie** · 11-01-2011, 03:45 AM

Hi, I need some help defining colors of my textboxes.
I have 7 textboxes, named 'txtFbRating' and a number from 1 to 7 behind this name.
(txtFbRating1, txtFbRating2 etc)
I want to have the interiorcolor to change with the value within the textbox. Values from 1 to 9
For example, if the value is 3, I want the interiorcolor to be RGB(240, 100, 25).

I've tried to code it, but it won't work, can someone help me out here?
here's what I've tried:

Please Login or Register  to view this content.

regards, Trudie

**john55** · 11-01-2011, 04:06 AM

hi
just try this one...

Please Login or Register  to view this content.

**snb** · 11-01-2011, 04:06 AM

The colouring of objects in a userform is different from that of cells in a worksheet.
This macro has to be put into the userform's macromodule.

Please Login or Register  to view this content.

**impartrudie** · 11-01-2011, 05:37 AM

Hi Snb and John55,

It seems neither of your proposals works...
Snb, could you explain your code? what does this line of code do?:

Please Login or Register  to view this content.

thanks, Trudie

**snb** · 11-01-2011, 05:49 AM

cfr. the attachment

**impartrudie** · 11-01-2011, 06:22 AM

hardstikke bedankt!,
ik probeer uit te vogelen hoe het in elkaar steekt, maar snap nog steed de kleurkodering niet - hoe hangt deze samen met de value?
regards,
Trudie