![]() |
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