| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie, Variables not retained in sub?
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....BU 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_eyeball ----------------------------------------------------------------------- NT_eyeballs's Profile: http://www.excelforum.com/member.php...fo&userid=3180 View this thread: http://www.excelforum.com/showthread.php?threadid=51526 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Newbie, Variables not retained in sub?
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Newbie, Variables not retained in sub?
or make it a Static variable.
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Gary''s Student" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Newbie, Variables not retained in sub?
Hey all, Thnx for replies. The variables Are dim'd in main. So I must be doing something wrong. The variable is loaded via Inputbox initially, and in the re-calc sub I am trying to allow the same variable to be re-loaded via another inputbox, but display previous value as Default. I have tried using a ghost variable (copy) as the default (in case inputbox statement is clearing it) and that doesn't work either. 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| row color is not being retained after saving spreadsheet | Excel Discussion (Misc queries) | |||
| Format & formula retained | Excel Worksheet Functions | |||
| Cell Content from UserForm Not Retained | Excel Discussion (Misc queries) | |||
| newbie ?: set variables, different shts, equal to each other | Excel Programming | |||
| Newbie Macro Query - Clearing Variables and Assigning a Variable | Excel Programming | |||
Hybrid Mode
