PDA

View Full Version : Display VBA assigned values



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?

apo
03-16-2015, 01:35 AM
Have you tried enabling the Locals Window in the VB Editor (View > Locals Window) while stepping though your code?

Juriemagic
03-16-2015, 01:48 AM
I know if I debug the code and you hold your pointer over the variable, you can see the current values, or one can open the Vb editor, but this is for looking at the values while looking at the code.(debugging)..

I am wondering if one can for example, when you click the button that sets of the code, view the criteria on the excel sheet, in other words without going into the actual module..