Good morning Patrick Simmonds

You'll kick yourself - really, you will :

change < for =.

thus:

If TextBox1.Text = "" And OptionButton4.Value = False An
OptionButton5.Value = False Then

HTH

Dominic

--
dominic
-----------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...fo&userid=1893
View this thread: http://www.excelforum.com/showthread.php?threadid=47166