Hello Dreamz,

The first line of Calculate should should look like this...

Public Sub Calulate(Byval chDep, ByVal chTr, Byval chHum)

If you have more varaiables add them to the list the same way. Thi
delaces the variables for you, so you don't need to have Dim statement
for each.

Sincerely,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=48062