textbox font colour

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pilot - 21 Mar 2008 11:44 GMT

I have a userform which has a number of textboxes. They are titled "Start
Date" and "Expiry Date".
How do I get the expiry date to change colour when 30 days before expiry
date the font changes to orange and when past the expiry date it changes to
red.
Is there a vb code to do that and if so where do I place it?

Signature

Pilot

Reply to this Message

houghi - 21 Mar 2008 15:22 GMT

> I have a userform which has a number of textboxes. They are titled "Start
> Date" and "Expiry Date".
> How do I get the expiry date to change colour when 30 days before expiry
> date the font changes to orange and when past the expiry date it changes to
> red.
> Is there a vb code to do that and if so where do I place it?

Conditional formatting is what I use. I would add a field that would
give me the number of days and then ket the conditional formatting
depend on these.

I actualy have an additional field where it not only changes colour, but
also tells me the status. This gives me the ability to use autofilter to
filter on it.

houghi

Signature

Let's not be too tough on our own ignorance. It's the thing that makes
America great. If America weren't incomparably ignorant, how could we
have tolerated the last eight years? -- Frank Zappa, in 1988

Reply to this Message

Pilot - 25 Mar 2008 16:13 GMT

If I conditional format the cells will the textbox 9which are linked to
cells) also change colour? or do I need to add a code so that the values in
the textbox will change colour?

Signature

Pilot

> > I have a userform which has a number of textboxes. They are titled "Start
> > Date" and "Expiry Date".
[quoted text clipped - 12 lines]
>
> houghi

Reply to this Message