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 Column A from record 6 on in the Sheet ReturnData (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.
What do you mean from record 6 on?
Do you want to exclude the first 5 records for some reason?
If posting code please use code tags, see here.
Exclude the first 5 records on the ReturnData sheet (they are heading/title rows etc, the records dont start until row 6).
So not the 6th record but the 1st record which is in row 6?
Your right I used the wrong word, I meant to say 6th row not record. My apologies.
Is this possible Norie?
Yes, and the code will look a lot like the other code that gets data from that worksheet based on what's selected in a listbox.
Assuming this is the same workbook as before of course.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks