I am trying to fix an application built by someone else that creates and exports several graphs and charts into Excel. It's having a problem with a couple of charts by copying over the data for the chart with data that should go somewhere else. A long time ago I knew how to "Step Into" the code, but can't get it to do anything now. I want to watch what the code does one line at a time.
How do I start Step Into? Right now when I select it from the Debug menu, nothing happens.
Once the first question is answered, what will I need to do to go from line to line? Spacebar, F8, ???
Also, for the user to begin the Export process he clicks on a button. There are a couple of lines that run before calling CreateExcelWorkbook. Where should I start the Step Into?
Private Sub btnExport_Click()
Me.optView.Value = 2