myChange is not defined in the sub VerifyOkay.
you defined it in the 1st block.
myChange is not defined in the sub VerifyOkay.
you defined it in the 1st block.
When i put the following code into the 2nd block everything is fine, but this would seem to be a waste of coding as i'm basically repeating code from the first block, so is their a method of defining the variables in the first block that the second block gets the required data?
![]()
If OpbTypeOne = True Then myVerify(6) = "Test 1" End If If OpbTypeTwo = True Then myVerify(6) = "Test 2" End If . .
I think i figured it out.
I change the following to the first sub routine
Then changed the second sub routine![]()
from Call VerifyOkay to Call VerifyOkay(myChange)
Then changed the myChange variable to myRev![]()
from Sub VerifyOkay() to Sub VerifyOkay(myRev)
Thanks all for pointing me in the right direction.![]()
Dim myVerify(1 To 6) As Variant myVerify(1) = txtPlanningNo.Value myVerify(2) = cboEngineer.Value . . . myVerify(6) = myRev(1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks