Setting tab positions?

[twgonder]

The tabs are driving me crazy in the VBA editor, always going 5 in, it’s too much space when I’m 5 or more levels deep. A third of the window is spaces. I’m going to get equivalent of lateral of whiplash!

In my old line editor there was a command to set tab spacing, something like this
.set tabs 5, 7, 9, 11, 13, 15, 17, 19


Then when I hit the tab key it indented 5 for the first line when tab was pressed, and the next line in nested situations would go 2 deeper with a tab press.

Is there a way to establish the tab positions (as in Word) in the VBA code editor?

And while I'm at it, why doesn't the Windows clipboard history work in the VBA editor? Isn't that kinda a big MS doh?

[Minty]

If you click
Tools ¬ Options
in the VBA editor there is a Tab Width setting you can adjust.

[Micron]

It's not like tabs on typewriters (which is what the OP sounds like) which could be 2 then 7 then 11 then 25... for as many tab stops the typewriter had. I guess it's practically unlimited in apps like Word. The VBE option controls how many spaces the cursor will indent when I hit the Tab key. I use 3.

[twgonder]

If you click
Tools ¬ Options
in the VBA editor there is a Tab Width setting you can adjust.

Thanks for that, you saved my neck.
A little odd though, if you put 2 in the tab, the first is at 3. The first always seems to be +1. But I can live with that.

[twgonder]

Now the real work is fixing all the horrible tabs I've got in some old code.
I haven't seen an auto indent/format feature yet.

[Minty]

I would invest in MZTools - it has a very handy Auto-Indenter.
It's been around for ages and has a number of very useful features, and a load of more things I should use and don't.

[isladogs]

There is also a free Smart Indenter utility

[Minty]

There is also a free Smart Indenter utility

Hi Colin - does it work with 64-Bit versions, I thought it didn't?

[isladogs]

Not sure. Apparently there is a trick to getting it working in A2013 onwards. See Installing Smart Indenter in Office 2013-2016 | Experts Exchange (experts-exchange.com)
I have it in 32-bit A365 but I also have A2010 on the same workstation.

Will investigate tomorrow on my 64-bit tablet PC