Just Dim the variables outside the sub.
--
Gary's Student


"NT_eyeballs" wrote:


Hey all,
Very new at teaching self VB in Excel.
Have created a simple loan repayment program (to learn with)
Got the basic 2 sheet code happening and am "prettying" it up.
Sheet 2 has a button to perform a Recalculate Option which works....BUT
it doesn't retain the values within the sub??

Do I have to "pass parameters" to sub???
If so....how is that done?

NT.


--
NT_eyeballs
------------------------------------------------------------------------
NT_eyeballs's Profile: http://www.excelforum.com/member.php...o&userid=31802
View this thread: http://www.excelforum.com/showthread...hreadid=515262