Defining Variables that pass to other Subs

[JasonSelf]

I have two Subs, in the first I define a variable and in the second I
recall this variable. here is how I am trying to do it (its not
working)


Private Sub TaskBox_Change()
Dim Task As String
Task = TaskBox.Value
End Sub

Public Sub Next()
ActiveCell.FormulaR1C1 = Task
End Sub

This is just a basic representation that I am trying to show of what is
not working. I can not figure out how I am to get the Variable defined
in the Sub "TaskBox_Change" passed to the Sub "Next"

Any help or guidance would be greatly appreciated.

 

[kkknie]

Here's how:

Define the variable on a module level. You code would read:

Dim Task As String

Private Sub TaskBox_Change()
Task = TaskBox.Value
End Sub

Public Sub Next()
ActiveCell.FormulaR1C1 = Task
End Sub

Any variable defined inside of a Sub is only available in that sub.

 

[JasonSelf]

thank you