ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Grouping/Collapsing lines in VBA editor - xl2000 (https://www.excelbanter.com/excel-programming/393525-grouping-collapsing-lines-vba-editor-xl2000.html)

Clayman

Grouping/Collapsing lines in VBA editor - xl2000
 
Is it possible in the VBA editor to group and/or collapse nested code? Example:
For x=1 to Len(empname)
currchar=Mid$(empname,x,1)
If currchar=" " Then
do something
Else
do something else
End If
Next x

Collapse the if-endif code leaving only the following visible:

For x=1 to Len(empname)
currchar=Mid$(empname,x,1)

Next x

I've used this in HTML editors and it's wonderful.
--
Adios,
Clay Harryman

Jim Thomlinson

Grouping/Collapsing lines in VBA editor - xl2000
 
Nope...
--
HTH...

Jim Thomlinson


"Clayman" wrote:

Is it possible in the VBA editor to group and/or collapse nested code? Example:
For x=1 to Len(empname)
currchar=Mid$(empname,x,1)
If currchar=" " Then
do something
Else
do something else
End If
Next x

Collapse the if-endif code leaving only the following visible:

For x=1 to Len(empname)
currchar=Mid$(empname,x,1)

Next x

I've used this in HTML editors and it's wonderful.
--
Adios,
Clay Harryman


Clayman

Grouping/Collapsing lines in VBA editor - xl2000
 
Rats!

Thanks, though!
--
Adios,
Clay Harryman


"Jim Thomlinson" wrote:

Nope...
--
HTH...

Jim Thomlinson


"Clayman" wrote:

Is it possible in the VBA editor to group and/or collapse nested code? Example:
For x=1 to Len(empname)
currchar=Mid$(empname,x,1)
If currchar=" " Then
do something
Else
do something else
End If
Next x

Collapse the if-endif code leaving only the following visible:

For x=1 to Len(empname)
currchar=Mid$(empname,x,1)

Next x

I've used this in HTML editors and it's wonderful.
--
Adios,
Clay Harryman



All times are GMT +1. The time now is 07:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com