When I pull up a Form and press F7 to see the code VBE will automatically add:

Sub BlahBlah_Click ()

End Sub

to the bottom of my existing code. How do I make this stop?

Hmm... not really what I was looking for. Pressing the F7 key allows me to
stay on the keyboard. And your method requires extra steps. I notice it
doesn't do this all the time. Surely there is a way to prevent it. Why else
would it do it on some forms and not others?

"Patrick Molloy" wrote:

> simple ...don't press F7!
>
> right-click the form and select View Code, or in the VBAProject window,
> select the form and click the code icon or again right-click and select View
> code
>
> "Bishop" <(E-Mail Removed)> wrote in message
> news:ED43E408-85A0-47E3-9852-(E-Mail Removed)...
> > When I pull up a Form and press F7 to see the code VBE will automatically
> > add:
> >
> > Sub BlahBlah_Click ()
> >
> > End Sub
> >
> > to the bottom of my existing code. How do I make this stop?
>

Hi,

Once you have the code window open you could use CTRL+TAB to return to it.

F7 on a userform will take you to an event of the active control.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Bishop" <(E-Mail Removed)> wrote in message
news:ED43E408-85A0-47E3-9852-(E-Mail Removed)...
> When I pull up a Form and press F7 to see the code VBE will automatically
> add:
>
> Sub BlahBlah_Click ()
>
> End Sub
>
> to the bottom of my existing code. How do I make this stop?

CTRL+Tab seems to have no discernable order. It takes me from the the code
for Form1 to Module3 to Module 7 to Form2 to code for Form3 so on and so
forth. How do I set the tab order?

"Andy Pope" wrote:

> Hi,
>
> Once you have the code window open you could use CTRL+TAB to return to it.
>
> F7 on a userform will take you to an event of the active control.
>
> Cheers
> Andy
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
> "Bishop" <(E-Mail Removed)> wrote in message
> news:ED43E408-85A0-47E3-9852-(E-Mail Removed)...
> > When I pull up a Form and press F7 to see the code VBE will automatically
> > add:
> >
> > Sub BlahBlah_Click ()
> >
> > End Sub
> >
> > to the bottom of my existing code. How do I make this stop?
>
>

If you click on the Form name in the Project Window and hit F7 it will simply
show you the code. If you click on the actual Userform and hit F7 then it
will go to the code window and auto-populate a new procedure.

"Bishop" wrote:

> When I pull up a Form and press F7 to see the code VBE will automatically add:
>
> Sub BlahBlah_Click ()
>
> End Sub
>
> to the bottom of my existing code. How do I make this stop?

The order is the same as the order of items under the Windows menu.

So if you want keystrokes only, ALT+W followed by the number of the window
to gain focus.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Bishop" <(E-Mail Removed)> wrote in message
news:7A685374-43DC-41C9-A6B2-(E-Mail Removed)...
> CTRL+Tab seems to have no discernable order. It takes me from the the
> code
> for Form1 to Module3 to Module 7 to Form2 to code for Form3 so on and so
> forth. How do I set the tab order?
>
> "Andy Pope" wrote:
>
>> Hi,
>>
>> Once you have the code window open you could use CTRL+TAB to return to
>> it.
>>
>> F7 on a userform will take you to an event of the active control.
>>
>> Cheers
>> Andy
>>
>> --
>>
>> Andy Pope, Microsoft MVP - Excel
>> http://www.andypope.info
>> "Bishop" <(E-Mail Removed)> wrote in message
>> news:ED43E408-85A0-47E3-9852-(E-Mail Removed)...
>> > When I pull up a Form and press F7 to see the code VBE will
>> > automatically
>> > add:
>> >
>> > Sub BlahBlah_Click ()
>> >
>> > End Sub
>> >
>> > to the bottom of my existing code. How do I make this stop?
>>
>>

understood. i get around this by double clicking a button or whatever that
has code written.
I agree , its a pain
- nope, I can't see how to prevent it I'm afraid

"Bishop" <(E-Mail Removed)> wrote in message
news:437D204F-83F2-45AF-B9F3-(E-Mail Removed)...
> Hmm... not really what I was looking for. Pressing the F7 key allows me
> to
> stay on the keyboard. And your method requires extra steps. I notice it
> doesn't do this all the time. Surely there is a way to prevent it. Why
> else
> would it do it on some forms and not others?
>
> "Patrick Molloy" wrote:
>
>> simple ...don't press F7!
>>
>> right-click the form and select View Code, or in the VBAProject window,
>> select the form and click the code icon or again right-click and select
>> View
>> code
>>
>> "Bishop" <(E-Mail Removed)> wrote in message
>> news:ED43E408-85A0-47E3-9852-(E-Mail Removed)...
>> > When I pull up a Form and press F7 to see the code VBE will
>> > automatically
>> > add:
>> >
>> > Sub BlahBlah_Click ()
>> >
>> > End Sub
>> >
>> > to the bottom of my existing code. How do I make this stop?
>>