+ Reply to Thread
Results 1 to 5 of 5

Fill userform from row based on unique value in one column

  1. #1
    Registered User
    Join Date
    09-28-2017
    Location
    New York City
    MS-Off Ver
    2016
    Posts
    24

    Post Fill userform from row based on unique value in one column

    I've built a userform to display all the details of a case; I want users to punch the unique ID to each customer into an input box (the value is stored in column J of the table on the tracking sheet), and fill the textboxes off that row.

    I know how to display values off a specific cell to a textbox; but I'm pretty weak on variables. How do I build the code for the textbox to display the value off the same row as the unique number the user enters?

    I've attached my working example with dummy lines of data. (The final form will have over 40 textboxes, which I can match to code. I really just need one example.)

  2. #2
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,740

    Re: Fill userform from row based on unique value in one column

    There is no attachment.
    Teach me Excel VBA

  3. #3
    Registered User
    Join Date
    09-28-2017
    Location
    New York City
    MS-Off Ver
    2016
    Posts
    24

    Re: Fill userform from row based on unique value in one column

    Gah! Sorry. Here we go.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    05-12-2018
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    259

    Re: Fill userform from row based on unique value in one column

    Why don't you use a combobox in the userform to choose the customer ID?
    Attached Files Attached Files
    Last edited by SjonR; 08-08-2018 at 07:12 AM.

  5. #5
    Registered User
    Join Date
    09-28-2017
    Location
    New York City
    MS-Off Ver
    2016
    Posts
    24

    Re: Fill userform from row based on unique value in one column

    That works great; I truly didn't think about using offset to find on the same row. Thank you very much!

+ 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] Auto-fill Unique Identifier based on another column
    By jekeith in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 05-04-2018, 09:13 AM
  2. [SOLVED] Count unique entries based off unique criteria in another column
    By hambly in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 06-11-2014, 03:33 PM
  3. Fill Column B based on non-unique values in Column A
    By viksmehta in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-21-2014, 07:39 AM
  4. [SOLVED] userform combobox2 does not have unique values and will not fill listbox
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-11-2013, 12:22 PM
  5. [SOLVED] auto fill with one column and multiple unique rows.
    By plague5050 in forum Excel General
    Replies: 5
    Last Post: 04-30-2013, 02:29 PM
  6. auto fill a spreadsheet on a userform based on a textbox value
    By cyclone77 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-03-2012, 11:38 PM
  7. Userform textbox to fill next blank cell in column
    By RaffertyL in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2012, 03:20 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