Results 1 to 3 of 3

Thread: Paste text 50 characters in to a cell? [Resolved]

  1. Nov 1st, 2003, 05:40 PM #1
    Pirre001
    Pirre001 is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jul 2002
    Posts
    665

    Question Paste text 50 characters in to a cell? [Resolved]

    I want to paste a text into a cell. The text should always start 50 characters in to the cell, regardless of wich text that are written before.
    How do I do that?
    Last edited by Pirre001; Nov 2nd, 2003 at 03:59 PM.
    Reply With Quote Reply With Quote
  2. Nov 1st, 2003, 06:55 PM #2
    MartinLiss
    MartinLiss is offline
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,431
    Text1.SelStart = 50
    Text1.SelLength = Len(Text1.Text) - 50
    Then paste in Text1.SelText
    Tips, Examples & Tutorials:
    A valuable forum tool • Generate unique TreeView keys • TreeView with "open" and "closed folder" icons • Time code using GetTickCount • How to trap the Tab key • Scroll a form • NumberBox ActiveX control • Color a ListView row • An InputBox form • How to use SaveSetting and GetSetting • A program registration scheme • Spellcheck a Textbox • Resize controls • Open Windows Explorer at Last Visited Path • A Blackjack Game • Count lines of code • Private Message Viewer • Copy/Paste VB Code • Paste VB Code Add-In • Insert Procedure Names Add-In • A calculator for the game of Spider • My review of REALbasic 2008 • VB6 Debug Tutorial • Picture/Video Viewer • VBF Photo Contest Winners


    2009 - 2016
    Reply With Quote Reply With Quote
  3. Nov 2nd, 2003, 03:58 PM #3
    Pirre001
    Pirre001 is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jul 2002
    Posts
    665
    Thanks!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width