Juriemagic
03-15-2015, 11:20 PM
Dear all,
I was wondering if it is possible to view ion an excel sheet, the "progress" of a VBA code?. So, If I have the following code:
Dim d1 As Double
Dim e1 As Double
Dim f1 As Double
Dim g1 As Double
Dim h1 As Double
Dim i1 As Double
Dim j1 As Integer
(THIS IS ONLY PART OF A CODE)..the rest of the code assigns values to these variables, and the code also loops the values, in other words, calculates different combinations to give a desired result. Is it possible to view on the working excel spreadsheet, the current values as is assigned to the variables?...in other words to "see" how VBA is working?
I was wondering if it is possible to view ion an excel sheet, the "progress" of a VBA code?. So, If I have the following code:
Dim d1 As Double
Dim e1 As Double
Dim f1 As Double
Dim g1 As Double
Dim h1 As Double
Dim i1 As Double
Dim j1 As Integer
(THIS IS ONLY PART OF A CODE)..the rest of the code assigns values to these variables, and the code also loops the values, in other words, calculates different combinations to give a desired result. Is it possible to view on the working excel spreadsheet, the current values as is assigned to the variables?...in other words to "see" how VBA is working?