just a quick observation:

Dim solutionapplied As Variant

solutiionapplied.Value = TextBox4.Text

are different. Typo in "solutiionapplied...."???
and because you don't define "solutiionapplied" you get the state
error?

Good luc

--
swatsp0

-----------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...fo&userid=1510
View this thread: http://www.excelforum.com/showthread.php?threadid=47720