Results 1 to 12 of 12

Add quotes to textbox and move cursor between them

Threaded View

JP Romano Add quotes to textbox and... 12-29-2010, 04:46 PM
Leith Ross Re: Add quotes to textbox and... 12-29-2010, 04:52 PM
JP Romano Re: Add quotes to textbox and... 12-29-2010, 04:55 PM
Leith Ross Re: Add quotes to textbox and... 12-29-2010, 05:10 PM
JP Romano Re: Add quotes to textbox and... 12-29-2010, 05:22 PM
JP Romano Re: Add quotes to textbox and... 12-29-2010, 05:23 PM
Leith Ross Re: Add quotes to textbox and... 12-29-2010, 05:39 PM
JP Romano Re: Add quotes to textbox and... 12-29-2010, 05:45 PM
JP Romano Re: Add quotes to textbox and... 12-29-2010, 05:52 PM
JP Romano Re: Add quotes to textbox and... 12-29-2010, 05:57 PM
Leith Ross Re: Add quotes to textbox and... 12-29-2010, 06:05 PM
JP Romano Re: Add quotes to textbox and... 12-29-2010, 06:07 PM
  1. #1
    Forum Contributor JP Romano's Avatar
    Join Date
    10-09-2008
    Location
    Princeton, NJ
    MS-Off Ver
    2010
    Posts
    500

    Add quotes to textbox and move cursor between them

    Hi...trying to figure out the best way to add quotation marks to a text box (which is on a sheet, not a userform) then move the cursor back one position between them.

    I can add them fine (the line below takes whatever string is already in the textbox, called InstructionsBox, and adds two double quotes to the end:

    InstructionsBox = InstructionsBox & Chr(34) & Chr(34)
    Now I think I need to set focus back to the textbox and move the cursor back between the quotation marks. The SetFocus method isn't available (though SELECT is), and my sorry attempt at using a send key isn't working either

    This seems so simple, but I just can't get it to work... any help is appreciated.
    Last edited by JP Romano; 12-29-2010 at 05:45 PM. Reason: SOLVED

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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