I'm looking for click event code for a list box called lbActiveItemList that finds a match for the selected record in Column 1, to ReturnData Sheet Column A from row 6 on (using the G column to find the last row). Upon finding a match it should close the userform, and make the G cell for the matching record the Active Cell.
difficult to say without an example.
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please send a sample with mock data with the expected results..
I have attached my workbook. On the ReturnData page click on the Active Equipment button at the top. Then select an item from either the top or middle list box to display records in the bottom list box. I would then like to be able to double click on a record within that bottom listbox (lbActiveItemList) and have it show that record in the worksheet, (and close the userform).
Thanks,
James
Any thoughts?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks