+ Reply to Thread
Results 1 to 2 of 2

vba to keep the text in one line only

  1. #1
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    695

    vba to keep the text in one line only

    Hi

    I have content control to write anything
    after the content control there is text "......." I want if content control updated with less or more length, the ..... still in same line and maxiumal to the right
    there userform for update the content

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,646

    Re: vba to keep the text in one line only

    Simply use a tab with a right-aligned tab-stop at the right margin and format the tab to use a dot leader.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 12
    Last Post: 10-08-2018, 02:53 PM
  2. Error Reading Text File Line By Line
    By bennyys in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-15-2018, 05:28 AM
  3. Italicize only the first line of a two text line cell
    By Pr0 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-31-2017, 09:01 AM
  4. [SOLVED] Reading line by line data from Text file
    By wyldencl in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-18-2015, 10:09 PM
  5. [SOLVED] Wanted: Highlight last line of text and copy to line below
    By King_Crud in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-17-2014, 08:01 AM
  6. Read the text in a single cell line by line.
    By moon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-14-2010, 06:23 AM
  7. Replies: 6
    Last Post: 07-12-2005, 04:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1