+ Reply to Thread
Results 1 to 4 of 4

User form text box generating values in specific cells

  1. #1
    Registered User
    Join Date
    07-01-2015
    Location
    United States
    MS-Off Ver
    Microsoft office standard 2007
    Posts
    52

    User form text box generating values in specific cells

    I have a user form with multiple text boxes. I want the different text box's to populate different cells in my workbook.

    for example text box1 should change cell D13 on the sheet "Input".

    This seems easy but i have not found what i am looking for yet.

    thanks in advance!

  2. #2
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: User form text box generating values in specific cells

    Here's the syntax, adjust the variables as needed.

    Please Login or Register  to view this content.
    I'm interested in starting a career working with VBA, if anyone knows of any opportunities!

  3. #3
    Registered User
    Join Date
    07-01-2015
    Location
    United States
    MS-Off Ver
    Microsoft office standard 2007
    Posts
    52

    Re: User form text box generating values in specific cells

    This is great. I put this command attached to a command button. I need to populate multiple cells in my sheet. I copy and pasted them back to back changing the cells and text box number. It is not working for me right now. here is my code
    Please Login or Register  to view this content.

  4. #4
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: User form text box generating values in specific cells

    Syntax looks good, would need to see workbook with userform.

+ 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. Need help auto generating a work order number in a user form
    By Losman in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-11-2016, 10:07 AM
  2. Replies: 0
    Last Post: 08-18-2015, 05:22 AM
  3. Issue populating values in User Form to proper cells on Sheet1
    By Grilleman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2015, 12:40 PM
  4. user form to fill in data into specific cells
    By bqheng in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-27-2014, 07:57 PM
  5. user form to fill in data into specific cells
    By bqheng in forum Word Programming / VBA / Macros
    Replies: 18
    Last Post: 05-22-2014, 09:29 PM
  6. [SOLVED] User Form to execute search and return all values to the user form for editing
    By allwrighty in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-11-2013, 10:40 PM
  7. How to create user form that displays values from cells
    By TomT in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-24-2008, 02:57 AM

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