+ Reply to Thread
Results 1 to 4 of 4

Prefill Text Form

  1. 11-06-2016, 06:48 PM #1
    tejboyd
    tejboyd is offline
    Registered User
    Join Date
    08-26-2014
    Location
    London,England
    MS-Off Ver
    2010
    Posts
    95

    Prefill Text Form

    Hi,

    Hoping someone can assist.

    I have a table with data and a form in sheet 2 with numerous text boxes.

    What I need is data in Column E (startung at E6) to be copied to Texbox 1 in sheet 2.

    Also for data in Column B (starting B6) to be copied to Textbox 27.

    The next step is for all the textboxes and data in sheet 2 to be generated into an email, when a button is selected.
    Reply With QuoteRegister To Reply
  2. 11-06-2016, 07:41 PM #2
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Prefill Text Form

    Hello tejboyd,

    Please post your workbook. It will remove any doubt about the layout and which type of controls you are using. It also provides a way to test a solution before posting it.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
  3. 11-09-2016, 07:25 PM #3
    tejboyd
    tejboyd is offline
    Registered User
    Join Date
    08-26-2014
    Location
    London,England
    MS-Off Ver
    2010
    Posts
    95

    Re: Prefill Text Form

    Hi,

    Attached is the spreadsheet.

    Also Textbox one is actually "Rectangle 15"

    Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 11-15-2016, 06:54 PM #4
    tejboyd
    tejboyd is offline
    Registered User
    Join Date
    08-26-2014
    Location
    London,England
    MS-Off Ver
    2010
    Posts
    95

    Re: Prefill Text Form

    Just wondering if anyone had any suggestions on this query.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Prefill text box in userform with today's date but allow user to enter unique date
    By moosetales in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-02-2014, 09:17 AM
  2. Prefill data in Tab A from Tab B
    By aBc894543 in forum Excel General
    Replies: 0
    Last Post: 05-10-2013, 06:31 AM
  3. [SOLVED] Use .text from previous text box in form to prefill text in second text box
    By chromachem in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-23-2012, 10:04 PM
  4. VBA for new row in a table plus prefill
    By wibble wobble in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-31-2011, 03:30 AM
  5. [SOLVED] How can I prefill a text field with leading 0s?
    By Sweetetc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-24-2006, 03:10 PM
  6. converting numbers to text and prefill text field with 0's
    By Jan Buckley in forum Excel General
    Replies: 2
    Last Post: 01-20-2005, 05:06 PM
  7. How do I convert dollars and cents to text, and prefill the cell .
    By Jan Buckley in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-20-2005, 04:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1