ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel default module when opening visual basic editor (https://www.excelbanter.com/excel-programming/415814-excel-default-module-when-opening-visual-basic-editor.html)

Mr TJA[_2_]

Excel default module when opening visual basic editor
 

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.


All times are GMT +1. The time now is 12:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com