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

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,303
Office Version
  1. 365
Platform
  1. Windows
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.
 

Forum statistics

Threads
1,141,589
Messages
5,707,267
Members
421,499
Latest member
Dpbj

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
Top