Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Opening Visual Basic Editor | Excel Discussion (Misc queries) | |||
please help : Excel visual basic editor | Excel Programming | |||
Can I run Visual Basic procedure using Excel Visual Basic editor? | Excel Programming | |||
How to disable Visual Basic Editor in Excel file | Excel Programming | |||
Visual Basic editor terminates Excel 2003 | Excel Programming |