Excel 2002 VBA TreeView node indentation is ridiculously too narrow.

Too narrow, that is, when the little "+"-icon expansion control is
present. I mean, look at it: indentation is only what, 3 or 4 pixels?

(Indentation of childless nodes where the "+" is absent is ample and
just fine.)

When you have a list of such "+"-prefixed nodes, they look more like
siblings than children of their parent.

TreeView is basically a good, semi-rich object, but a
Node.IndentAmount property seems to be a no-show.

I don't suppose there's a way to increase node indentation? Or
alternatively, hide the "+" expansion control (which rather
pervsersely, I don't need since I usu. navigate with the arrow keys)?

Thanks much.

***

P.S. Say, I just had a thought. I've never used node icons before, but
if I set every node's icon to an invisible little white space, maybe
that'll shift everyone over?

If (big if) I can learn how to do node icons, I'll report what I find.

***

Er...heh-heh...so I looked just now for a Node.Icon property in VBA
Help and found none. What the?

Must be thinking of Object Pascal's treeview instead.

Demote my calling VBA TreeView semi-rich to one-third rich.

***

Aw, damn. It's the psychedelics again.

I guess Node.Image is what I'm looking for.

***

Hi,

The indentation is for the whole tree rather than each node.

TreeView1.Indentation = 40

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Jim Luedke" wrote in message
...
Excel 2002 VBA TreeView node indentation is ridiculously too narrow.

Too narrow, that is, when the little "+"-icon expansion control is
present. I mean, look at it: indentation is only what, 3 or 4 pixels?

(Indentation of childless nodes where the "+" is absent is ample and
just fine.)

When you have a list of such "+"-prefixed nodes, they look more like
siblings than children of their parent.

TreeView is basically a good, semi-rich object, but a
Node.IndentAmount property seems to be a no-show.

I don't suppose there's a way to increase node indentation? Or
alternatively, hide the "+" expansion control (which rather
pervsersely, I don't need since I usu. navigate with the arrow keys)?

Thanks much.

***

P.S. Say, I just had a thought. I've never used node icons before, but
if I set every node's icon to an invisible little white space, maybe
that'll shift everyone over?

If (big if) I can learn how to do node icons, I'll report what I find.

***

Andy:

A (very) belated thank you for your reply.

***