+ Reply to Thread
Results 1 to 3 of 3

Putting Data in a Worksheet from Text boxes in a user form

  1. #1
    Registered User
    Join Date
    09-26-2022
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2

    Putting Data in a Worksheet from Text boxes in a user form

    I am doing the following code to take the data inputted into my user form text boxes into cells in my worksheet. Is there a better way to do it than the code below? It works, but I have a lot to input.

    Please Login or Register  to view this content.
    Last edited by AliGW; 09-27-2022 at 09:20 AM. Reason: Code tags added & thread moved to correct section.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,933

    Re: Putting Data in a Worksheet from Text boxes in a user form

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (Note: this change is not optional. As you are new here, I have done it for you this time.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,239

    Re: Putting Data in a Worksheet from Text boxes in a user form

    Quick question...Why would you change the Default TextBox Names from TextBox1 to VFAddOnData1...Makes no sense?

    Anyway...This is a slight simplification...
    Please Login or Register  to view this content.
    Could also do it this way...I make use of above...
    Please Login or Register  to view this content.
    Last edited by sintek; 09-27-2022 at 09:42 AM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

+ 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. User Form - Many Text Boxes - Restrict One Text Box with Password for Editing
    By kavi.sundar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-06-2019, 07:42 PM
  2. [SOLVED] Concatenate user form text boxes values
    By bala04msw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-29-2018, 06:27 AM
  3. Populate text boxes on user form, from combo box on same user form
    By Richardswaim in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 07-03-2016, 09:35 AM
  4. Data Validation between text boxes on user form
    By batmom2 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-05-2015, 03:33 PM
  5. Replies: 1
    Last Post: 08-28-2013, 05:04 PM
  6. User Form Basics - Populating Text Boxes
    By T.J. Lanza in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-24-2009, 03:48 AM
  7. [SOLVED] User form and text boxes on charts
    By Joel Mills in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-17-2005, 06:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1