Understanding VBA Code

[SKV]

Hi,

I am just an average VBA coder and looking for some advice from the experts in this forum. Basically I am looking for 2 things.

1. Any free application which auto-indents the VBA code
2. Any application then can help understand the loops in the code.......I have written a 300 line code but now having hard time to modifify the logic as I get confused on the existing loops.

Any advise is greatly appreciated.

 

[bs0d]

I'm not an expert, but I may have a tip. While there are debugging features, one simple thing you could do is temporarily code in alerts with bits of information through certain portions of the function of sub you're writing. This will help you confirm what's happening, when, which conditions are being met, and the values of variables and so on. This is especially useful if your code is dependent on interaction from the user.

I'm pretty sure VBA should auto indent. Try: Tools --> Options --> Editor tab: Auto Indent checkbox and tab width input.

 

[Micron]

Any application then can help understand the loops in the code

This is why documentation within the code is important. You might understand it now, but much later...

 

[SKV]

hi - can you please elaborate more on " code in alerts" what does it mean? is there an option in VBA to run code in alert? Also I checked your suggestion on auto indent and I see that option but how to activate it as it is checked in machine but it does nothing.

 

[bs0d]

hi - can you please elaborate more on " code in alerts" what does it mean? is there an option in VBA to run code in alert? Also I checked your suggestion on auto indent and I see that option but how to activate it as it is checked in machine but it does nothing.

I'm just saying you can add some lines like this:

Msgbox "Variable123 value is: " & Variable123 & "; Variable234 is: " & Variable 234

 

[xenou]

Code indentation. I have used this one:
Office Automation Ltd. - Smart Indenter

also you could try this:
Andrew's Excel Tips: Downloads