Tom,

My link in the main code was 'Range("PROCEEDS").Value = Cash';
changed this to 'Range("PROCEEDS").Value
CDbl(txtCASH_REQUIRED.Text)'. I then received an Error 424 messag
(Object Required). I then inserted
'Public txtCASH_REQUIRED As String' outside the procedure but in th
same module. I then received a Compile error message ("Invali
qualifier") on
txtCASH_REQUIRED in the second Range("PROCEEDS").Value stmt above.

Chuckles12

--
Chuckles12
-----------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...fo&userid=1494
View this thread: http://www.excelforum.com/showthread.php?threadid=27890