Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto code in VBE when pressing F7
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto code in VBE when pressing F7
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" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto code in VBE when pressing F7
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" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto code in VBE when pressing F7
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" wrote in message ... 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" wrote in message ... 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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ok, I figured it out
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto code in VBE when pressing F7 | Excel Programming | |||
VBA code for pressing "down arrow" in recording macro | Excel Programming | |||
Pressing a CommandButton on a Userform via Code | Excel Programming | |||
Command button auto select after pressing Enter | Excel Programming | |||
auto zip code | Excel Worksheet Functions |