+ Reply to Thread
Results 1 to 3 of 3

Populate a textbox with selected text

  1. #1
    Registered User
    Join Date
    10-25-2012
    Location
    Ne/Ia
    MS-Off Ver
    office 2016
    Posts
    52

    Populate a textbox with selected text

    I would like to create a place on a bid form for a text box containing inclusions and exclusions. The two textboxes would be filled based on the Yes/No from a checkbox next to a list of items. i would like to add them with a comma and a space, and if there is a reference note add it in parentheses.

    ---Grade Beams (s-1), Footing Pads, Curbs (c-1)---

    Attached is an example with no code.
    Attached Files Attached Files

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Populate a textbox with selected text

    See if this gets you close.
    Attached Files Attached Files
    David
    (*) Reputation points appreciated.

  3. #3
    Registered User
    Join Date
    10-25-2012
    Location
    Ne/Ia
    MS-Off Ver
    office 2016
    Posts
    52

    Re: Populate a textbox with selected text

    thank you Tinbendr,

    that is a good example, my understanding of code is minimal. I attached a better example of the way i would like to use the functions.

    found some code that will work, but it is a lot of typing; sample:
    Please Login or Register  to view this content.
    Your version has an if then for the additional column that i am not sure how to incorporate:
    Please Login or Register  to view this content.
    I have never used Msg$ or .OLEObjects before
    Attached Files Attached Files
    Last edited by Hooty; 07-03-2019 at 04:49 PM.

+ 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. trying to populate a listbox with rows from sheet then when selected split into textbox
    By justlearning123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-15-2015, 06:45 AM
  2. [SOLVED] Populate Cell Comment text in UserForm TextBox
    By pipoliveira in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-04-2014, 10:48 AM
  3. Textbox with text that can be selected and copied but not changed
    By runwest in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-06-2013, 04:56 PM
  4. Get the user selected text from a textbox in VBA
    By LoomisP in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-06-2012, 06:13 AM
  5. Multiline textbox where the text can be selected and copied but not edited
    By Brunstgnegg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-19-2010, 06:53 AM
  6. Can't see cursor or selected text in textbox even though it has fo
    By KHanna in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-19-2006, 11:30 AM
  7. Highlight all Text in a Textbox when the textbox is selected
    By RPIJG in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-28-2005, 03:28 PM

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