Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there any way to collapse/expand codes in VBA editor?
How to expand/collapse the codes in VBA programming window?
is there any plug-in or software to make it? thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there any way to collapse/expand codes in VBA editor?
I know of no way to do exactly what you want (wish I did), but you can set
it up so that the window only shows one procedure at a time (ToolsOptionsEditorWindow SettingsDefault to Full Module View - uncheck it). I don't like it, but it is available. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "iop" wrote in message ... How to expand/collapse the codes in VBA programming window? is there any plug-in or software to make it? thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there any way to collapse/expand codes in VBA editor?
thanks.
though we can switch the views of one / all procedure(s) by clicking the bottom left of the editor window, only showing the one procedure is not enough. ;) codes with "if... then", "while,... wend", etc, especially need to be collapsed and expanded. it can be done in Visual Basic 2008. it seems we've to wait for the next version of VBA. :( "Bob Phillips" wrote: I know of no way to do exactly what you want (wish I did), but you can set it up so that the window only shows one procedure at a time (ToolsOptionsEditorWindow SettingsDefault to Full Module View - uncheck it). I don't like it, but it is available. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "iop" wrote in message ... How to expand/collapse the codes in VBA programming window? is there any plug-in or software to make it? thanks! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there any way to collapse/expand codes in VBA editor?
There isn't going to be a 'next version of VBA'.
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "iop" wrote in message ... thanks. though we can switch the views of one / all procedure(s) by clicking the bottom left of the editor window, only showing the one procedure is not enough. ;) codes with "if... then", "while,... wend", etc, especially need to be collapsed and expanded. it can be done in Visual Basic 2008. it seems we've to wait for the next version of VBA. :( "Bob Phillips" wrote: I know of no way to do exactly what you want (wish I did), but you can set it up so that the window only shows one procedure at a time (ToolsOptionsEditorWindow SettingsDefault to Full Module View - uncheck it). I don't like it, but it is available. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "iop" wrote in message ... How to expand/collapse the codes in VBA programming window? is there any plug-in or software to make it? thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Expand Collapse Buttons | Excel Discussion (Misc queries) | |||
Expand and Collapse groups | Excel Programming | |||
Outline, expand or collapse via VBA | Excel Programming | |||
Expand and Collapse Columns | New Users to Excel | |||
expand/collapse row button | Excel Discussion (Misc queries) |