Forgoten how to Step into VBA Code

KeithSandum

New Member
Joined
Oct 17, 2006
Messages
1
Its been several years since I used VBA in Excel, but an old programme I wrote has thrown up a bug.
My problem is that I have forgoten how to step into code associated with a command button.
The way I am trying is to open the associated form using the Project explorer, then right click the buton and select the show code option.
This works and I get the code displayed, but when I use the VBA toolbar to step into the code it steps into the code directly associated with the Form instead! -----ugggg
Can anyone out there stop me from going crazy?
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
What you probably want to do is set a breakpoint somewhere in the button's code using F9.

Then run the form, hit the button and you should be able to step through the code with F8.
 
Upvote 0

Forum statistics

Threads
1,214,798
Messages
6,121,635
Members
449,043
Latest member
farhansadik

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top