M
Mr TJA
Why does the visual basic editor open to a module that is not my most recent
runned module. It is not even one is alphabetically on top of the list. Is
the default the last "built" module name?
It seems to open to the last module that was run, that has a call stmt in a
separate call sub , above that sub. And also that module's run was logged,
and the log was dumped into a worksheet.
When I run a module called "exp", and save excel, then reopen and click
visual basic editor it keeps going back to some other module (as I stated the
details above)
Sub CallFix()
For ii = 1 To 24
Call FixSpd("Vn")
Call FixSpd("PUB")
Next ii
End
End Sub
Sub FixSpd(fx$)
Dim test As Boolean, outs As Object, inps As Object
Dim r$(20), bn$(5)
.....
......
end sub
this module is where vb editor opens too, not my last run module which has
no "call module" over the main code.
runned module. It is not even one is alphabetically on top of the list. Is
the default the last "built" module name?
It seems to open to the last module that was run, that has a call stmt in a
separate call sub , above that sub. And also that module's run was logged,
and the log was dumped into a worksheet.
When I run a module called "exp", and save excel, then reopen and click
visual basic editor it keeps going back to some other module (as I stated the
details above)
Sub CallFix()
For ii = 1 To 24
Call FixSpd("Vn")
Call FixSpd("PUB")
Next ii
End
End Sub
Sub FixSpd(fx$)
Dim test As Boolean, outs As Object, inps As Object
Dim r$(20), bn$(5)
.....
......
end sub
this module is where vb editor opens too, not my last run module which has
no "call module" over the main code.