Auto Indent - Setting on MacOS Where

[lord anubis]

HI,

I did see a screen shot of Auto Indent in the windows version,but what about the Mac version?

Is there a setting, macro or addin available that indents the code in VB editor?


Any suggestions appreciate.

LA

[rorya]

Not that I know of. Few Windows versions work with 64bit Excel and I don't know of any Mac add-ins for the VBE.

[lord anubis]

Pitty, was afraid of that.


Is there a way to get the vb editor under control with VBA?
I think of a piece of code that wil get executed when I Press a Key ShortCut and then control the text in a VB Editor top window.

[rorya]

I honestly couldn't say. I hate trying to program in Mac Excel so avoid it if at all possible.

[lord anubis]

Me too, it is a crime, but have no Windows.

[rorya]

The last time I wrote something like that, it used a COM add-in (dll) and I don't know how/if you can create a Mac compatible version of those.

[lord anubis]

Thank you for your idea. Unfortunate, I have no idea either. If I could find a sample that can touch the VBA editor using Swift or Obj-C then I could try.