Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,101
Default Removing textbox padding, how to please, Excel 2000/2003

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,
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 860
Default Removing textbox padding, how to please, Excel 2000/2003

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]


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Removing textbox padding, how to please, Excel 2000/2003


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


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=485036

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing Links from Excel 2000 Arvind Excel Discussion (Misc queries) 1 June 23rd 08 08:38 PM
Imported into Vista, how to delete 2000 Excel textbox? Hank Excel Discussion (Misc queries) 0 May 4th 07 11:17 PM
Removing Carriage Returns in Excel 2000 Toby Stevenson Excel Discussion (Misc queries) 5 June 2nd 05 12:25 AM
Removing links to other workbooks-Excel 2000 ktroupe70 Excel Worksheet Functions 4 May 4th 05 10:33 PM
Help needed with textbox formatting in Excel 2000 JIMBROOKS Excel Discussion (Misc queries) 1 January 1st 05 03:33 PM


All times are GMT +1. The time now is 03:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"