+ Reply to Thread
Results 1 to 3 of 3

returning data from each row in text box

  1. #1
    Registered User
    Join Date
    11-22-2018
    Location
    england
    MS-Off Ver
    2013
    Posts
    12

    returning data from each row in text box

    Hi,

    Could anyone help please. What i want to do is to work on data from each row. basically to return cell values into txtbox from row 1 and then run some other macros and move to next row. something like: txtbx1 = a1 txtbx2 = b1 then call some macros and go to next row: txtbx1 = a2 txtbx2 = b2 and call some macros and carry on this until empty row found. Have not got any code written yet on this.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,445

    Re: returning data from each row in text box

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Registered User
    Join Date
    11-22-2018
    Location
    england
    MS-Off Ver
    2013
    Posts
    12

    Re: returning data from each row in text box

    I can not upload the book that I am working on, because it has sensitive information on it so I have attached example book. basically I have a list of employees that need to be upgraded, and currently I have to add each of them details manually in my userform. so i would like a code to do it for me. all I need it to do is add details about employee from upgrade sheet and then my other macro will look up what they current grade is and will count what add pay they need and will paste in add pay sheet. I have all the other macros written just would like to have a code so it takes data from each row automatically.
    Attached Files Attached Files

+ 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. [SOLVED] Looking for a single text value and returning 1 or multiple text values in one cell
    By cramnij in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-07-2014, 04:59 AM
  2. Replies: 7
    Last Post: 05-06-2014, 11:34 AM
  3. [SOLVED] Need help returning text if Data meets certain criteria
    By sumner06 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-24-2014, 01:06 PM
  4. Replies: 3
    Last Post: 05-03-2012, 04:00 PM
  5. Replies: 5
    Last Post: 04-16-2012, 06:21 AM
  6. Returning the Range value for specific text within a list of Data
    By WM7 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-27-2012, 09:04 PM
  7. Replies: 6
    Last Post: 07-15-2009, 07:44 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