I am sure this should be easy :

I am trying to get excel to do a calculation via textboxes.

For example

If textbox1.value textbox2.value then
Textbox1.forecolor = "red"
else
Textbox1.forecolor = "green"
end if

It maybe a little more complex because my values are in
date format. i.e. textbox1 = "01 jan 2003" textbox2 = "01
jan 2004"

Many thanks in advance

MArcus