[SOLVED] Removing textbox padding, how to please, Excel 2000/2003

[Mike]

Hi! I have an Excel 2003 file with multiple textboxes placed directly onto
the sheet. I noticed that when I click or tab to any of the textboxes, the
cursor is not placed directly to the left edge. It seems to me that it's off
1-2 characters to the right like the textbox is padded. Is there a way to get
rid off such "padding" ?
I can not seem to figure out how to.

Please help.

Many Thanks in Advance,

[Leith Ross]

Hello Mike,

It isn't padded. What you see is the Selection Margin. Clicking in that space will select all the text. To turn it off, set the SelectionMargin property to False.

Sincerely,
Leith Ross

[Jake Marx]

Mike,

Mike wrote:
> Hi! I have an Excel 2003 file with multiple textboxes placed directly
> onto the sheet. I noticed that when I click or tab to any of the
> textboxes, the cursor is not placed directly to the left edge. It
> seems to me that it's off 1-2 characters to the right like the
> textbox is padded. Is there a way to get rid off such "padding" ?
> I can not seem to figure out how to.

If these are ActiveX controls, you can set the SelectionMargin property to
False.

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]