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?
--
Pilot

Pilot wrote:
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
--
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

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?
--
Pilot


"houghi" wrote:

Pilot wrote:
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
--
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