[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 506
  • Last Modified:

Need Help Formating and Align VBA Code

I have a huge worksheet event code. Is issue is its huger and not aligned properly.
Its appearing like this
     Main loop
Loop1

                         Loop1 end


Loop2
           Loop2End

               .Loop3
                          Loop3 End
.
.
..
Main loop end
-----------------------------------------------------------------

What I like the vba c ode to ...be aligned neat and clean like below...

Main Loop
      Loop1
      Loop1End


         Loop2
       Loop2 End
             .
      .


Main Loop end

Issue is I am not sure which loop / Condition bracket ends where – as it not aligned properly and there are zillion lines of code. Is it possible to use a editor or something that highlights or lets me know or indicates - where one loop / Condition bracket starts and finishes ?
 That way I can realign and organize the code to look better and manageable. Right now it’s a jungle of mess
0
Rayne
Asked:
Rayne
  • 2
1 Solution
 
RayneAuthor Commented:
Thank you
0
 
Jared_SCommented:
You'll have to use something like smart indent. You can download it here...

http://www.oaltd.co.uk/Excel/Default.htm
0
 
RayneAuthor Commented:
Hello Jared_S,
This is Perfection to the THE Ultimate
Thank you for the turbo quick response :)
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now