Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
More VBA Editor weirdness
When I view the code in a module, it now defaults to showing General /
Declarations and I can select procedures one at a time. What do I need to change so that I can see the entire module? Thanks, Barb |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
More VBA Editor weirdness
There are two "views" to the code pane.
At the bottom left (just to the left of the left scroll arrow), you'll see two little icons. One looks kind of like this: --- -- --- And the other looks like: --- -- --- -- --- The leftmost is the "Procedure view" and the other is the "full module view". You'll see these in the tooltip if you let the cursor linger over them. Click the one you want. Each can be useful at different times. (You can scroll up/scroll down to move between procedures, too--in either mode.) Barb Reinhardt wrote: When I view the code in a module, it now defaults to showing General / Declarations and I can select procedures one at a time. What do I need to change so that I can see the entire module? Thanks, Barb -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
More VBA Editor weirdness
In addition to Dave's method to dynamically swap back and forth between the
two view methods, you can set the default view from Tools/Options on the Editor tab... the "Default to Full Module View" check box in the "Window Settings" section controls which default view is used at start up. -- Rick (MVP - Excel) "Barb Reinhardt" wrote in message ... When I view the code in a module, it now defaults to showing General / Declarations and I can select procedures one at a time. What do I need to change so that I can see the entire module? Thanks, Barb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arrow key weirdness | Excel Discussion (Misc queries) | |||
VBE Weirdness | Excel Programming | |||
Weirdness | Excel Programming | |||
VBA IDE Weirdness.... | Excel Programming | |||
Charting Weirdness and VBA | Excel Programming |