Limited Code shown in developer window

[peterhw]

I have just joined this forum because I was having trouble with the formats for displaying my code in VBA

My first problem was not being able to 'dock' windows - shown on this post and solution suggested by Marcelo Branco (thank you)

http://www.mrexcel.com/forum/showthread.php?t=607518

Having implemented the above solution I now find that the code shown in the code window is only one object at a time -i.e.

Private Sub CommandButton1_Click()
shows only the code associated with this button ( in this case 4 lines)

similarly
Private Sub CommandButton2_Click()
shows only the code associated with this button

In the past I have been able to scroll up and down over several different objects but I can only access 1 object at a time by selecting from the drop down menu (i.e. userform, textbox1, CommandButton1 etc)

 

[Hermanito]

At the bottomleft corner of the codewindow, two little buttons are 'hidden' (at least in my experience, noone ever seems to know they're there ).
One gives you procedure view, which you are in now, the other gives you full module view, and that is the one you need right now

 

[peterhw]

At the bottomleft corner of the codewindow, two little buttons are 'hidden' (at least in my experience, noone ever seems to know they're there ).
One gives you procedure view, which you are in now, the other gives you full module view, and that is the one you need right now

Spot on - thanks - works straight away.

Understand what you say - you never notice them!

 

[Firefly2012]

That was a new one on me! Boy would that be annoying to have clicked on the proc view

 

[Hermanito]

Hehe, glad I can still learn you some new tricks Firefly

The annoying thing about those buttons is that this setting cannot be changed anywhere else, not via the menu, not via VBA... so if you don't see them, you're f#@[ed ...

You can read the current setting in VBA with

Debug.Print Application.VBE.ActiveCodePane.CodePaneView

which will return 0 for procedure view and 1 for module view.

 

[RoryA]

The annoying thing about those buttons is that this setting cannot be changed anywhere else, not via the menu, not via VBA... so if you don't see them, you're f#@[ed ...

Tools-Options, Editor tab, Window settings, 'Default to full module view'. You may have to toggle it off then on though.

 

[Marcelo Branco]

At the bottomleft corner of the codewindow, two little buttons are 'hidden' (at least in my experience, noone ever seems to know they're there ).
One gives you procedure view, which you are in now, the other gives you full module view, and that is the one you need right now

Wow... completely new for me also
Thank you for sharing this

M.

 

[Hermanito]

Good catch rorya... I didn't think to check there...

 

[peterhw]

Glad I was able to raise such an interesting question!

Thanks again