Results 1 to 13 of 13

Use listbox selection and match function to populate controls on userform from dataset

Threaded View

  1. #1
    Registered User
    Join Date
    02-25-2017
    Location
    Bloemfontein South Africa
    MS-Off Ver
    2019
    Posts
    56

    Use listbox selection and match function to populate controls on userform from dataset

    Hi everyone.
    I am back now with another request for help with my Update/Edit procedure.
    I am using a userform(frmSearch) to search for a record in the dataset (NumbersDB) to UPDATE the record for now. The user form has a Listbox with textbox and Combobox controls on it. This part is working correctly but it is not really what I want to achieve..

    I am looking for help with the following:

    1) When I make a selection (Dble_Click) in the Listbox I want to highlight the correct Row on the Sheet(NumberDB) AND populate the controls DIRECTLY FROM THE Sheet(NumberDB) and NOT from the Listbox. I know you must use the Match function for this but I do not know how to do this.
    2) I also want to show the selected Row number from the Sheet(NumberDB) in the txtMatchRowNo. Currently, I am showing the SNo in the Dataset and this will differ from the Row number in the Sheet as the dataset is starting on Row 6

    I am including my workbook for easy reference.
    Thanking you all in advance for helping me.
    Attached Files Attached Files
    Last edited by DawidV; 10-16-2021 at 08:35 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Populate controls based on selected multicolumn Listbox item
    By terriertrip in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-13-2017, 04:30 PM
  2. Replies: 0
    Last Post: 03-29-2017, 10:09 AM
  3. [SOLVED] Userform Multi-Select Listbox Selection Condition to unhide Frame and controls
    By pjbassdc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2016, 10:05 AM
  4. Populate (ca 200) Txtboxes depending on listbox selection, live-filter for listbox &1 more
    By InternInNeed in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-14-2016, 09:56 AM
  5. Replies: 1
    Last Post: 05-30-2015, 12:15 PM
  6. Populate a Userform from a selection on a popup search listbox
    By ahmadassaad in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 10-16-2012, 09:00 AM
  7. populate listbox based on selection in previous listbox
    By sarahng86 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-28-2007, 10:55 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