+ Reply to Thread
Results 1 to 2 of 2

UserForm code that transfers only relevant rows to sheet

  1. #1
    Forum Contributor
    Join Date
    02-13-2018
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    198

    UserForm code that transfers only relevant rows to sheet

    Hello,

    on Sheet1 I want the userform to transfer the data only to the rows and columns in the code. In this case, I need row 8, 26 and 31. Row 8 is a combobox, row 26 is a textbox and row 31 is an optionbox. I will likely need to add more data transfers to rows further down on the sheet, so I need a process inside the userform code that allows me to do that. I have attached the userform and the code that I have built for it so far. Any help is appreciated, thanks!
    Attached Files Attached Files
    Last edited by Shruder; 03-11-2024 at 06:42 PM. Reason: grammer

  2. #2
    Forum Contributor
    Join Date
    02-13-2018
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    198

    Re: UserForm code that transfers only relevant rows to sheet

    I was able to take out the "rsh" in the code and it worked to transfer data. Marking this thread solved now.

    Please Login or Register  to view this content.
    code that worked below
    Please Login or Register  to view this content.

+ 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. VBA code for store inventory transfers
    By halimgunawan in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-18-2020, 01:02 PM
  2. Enter data on 1 sheet, it transfers to another sheet
    By Spookman01 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-28-2017, 05:19 PM
  3. Replies: 6
    Last Post: 12-23-2013, 11:01 AM
  4. Dialogue box to search date range of table column, copy relevant rows to report sheet
    By Tim Newton in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 08-26-2013, 03:10 AM
  5. Replies: 4
    Last Post: 03-01-2010, 06:12 PM
  6. Replies: 2
    Last Post: 03-23-2009, 10:17 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