• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA IDE F8 debugging short cut [SOLVED]

A

arishy

Member
Is it possible to avoid key pressing F8 while stepping into a vba procedure?.

If I can customize the ribbon to click on an icon that will trigger F8, so I move one step at a time while debugging; thus avoiding the keyboard.!!!
 
Good day arishy


Not sure how much shorter you can get than one key press but maybe this link will help


http://www.cpearson.com/excel/DebuggingVBA.aspx
 
Hi, arishy!


Adding my two cents to what b(ut)ob(ut)hc told you, there're 3 ways to avoid using the keyboard for debugging line to line VBA code:

1) Using a standard feature of the VBA editor: Debug, F8, but it isn't user friendly, 2 clicks.

2) Using a customizable feature of the VBA editor: View, Toolbars, Debug, and there you'll find at the 6th button/icon the step by step mouse access.

3) Using a standard customizable feature or the VBA editor: View, Toolbars, Customize, Commands, and select the F8 equivalent button and drag&drop it on any toolbar.


If I were you, I'd choose the 2nd.


Regards!
 
Hi, arishy!

Glad you solved it. Thanks for your feedback and for your kind words too. And welcome back whenever needed or wanted.

Regards!
 
You must log in or register to reply here.
Back
Top