Consulting

Results 1 to 3 of 3

Thread: Solved: textbox.SelStart Excel 2004 no effect?

  1. #1
    VBAX Mentor tpoynton's Avatar
    Joined
    Feb 2005
    Location
    Clinton, MA
    Posts
    399
    Location

    Solved: textbox.SelStart Excel 2004 no effect?

    follow up to this post , where a sample workbook is provided.

    while no error is presented, nothing happens. tried changing the value to 1, 10, and 100 with the same result...

    the property is listed in VBA help on mac, so it's curious that it doesnt seem to work...

  2. #2
    VBAX Mentor tpoynton's Avatar
    Joined
    Feb 2005
    Location
    Clinton, MA
    Posts
    399
    Location
    OK, found the answer and a better way to set a multiline textbox to the first line that works on both mac and PC platforms...

    [vba]
    With TextBox1
    .SetFocus
    .CurLine = 0
    End With
    [/vba]

    the curline property is listed in VBA help...just didnt find it soon enough

  3. #3
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Thanks for posting your solution Tim, that was an interesting little problem.
    Last edited by Bob Phillips; 07-31-2007 at 01:51 PM.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

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