+ Reply to Thread
Results 1 to 5 of 5

Option buttons to prduce a sentence into textbox

  1. #1
    Registered User
    Join Date
    10-14-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    78

    Option buttons to prduce a sentence into textbox

    Hi

    I have attached a sample of what i would like to do, I have 3 option buttons and a textbox, sheet1, with cells ABCD, the text in cell A1 to be populated by option button 1, B1 option2 and so on, when chosen they are to appear in textbox, they are to follow on to create a sentence in the textbox and then populate into cell D on sheet.

    thanks if you can help
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Option buttons to prduce a sentence into textbox

    Please Login or Register  to view this content.
    If solved remember to mark Thread as solved

  3. #3
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Option buttons to prduce a sentence into textbox

    Code for Userform module:-
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    10-14-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    78

    Re: Option buttons to prduce a sentence into textbox

    Hi
    Thanks

    Is there a way to make sure there is a space between the last word and then the beginning of the next, also is there a way that the text is wrapped when it populates into cell d1, it seperates and is in its own line under each one

  5. #5
    Registered User
    Join Date
    10-14-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    78

    Re: Option buttons to prduce a sentence into textbox

    Thanks very much its works brilliant

+ 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. Looping through userform option buttons, textbox and labels
    By Gal403 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-07-2014, 09:03 AM
  2. enable certain combo buttons based on user selected option buttons
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-20-2013, 06:43 AM
  3. Changing Textbox From Grey to Enabled and Back Again With Option Buttons
    By stuu3270 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-24-2013, 04:59 AM
  4. How can I insert multiple sets of option buttons (radio buttons) in Excel 2010?
    By mickwooduclan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-25-2013, 10:01 AM
  5. [SOLVED] Disabling an Entire Frame with Option Buttons if other Option Buttons are not clicked.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-20-2012, 04:07 AM

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