I have a listbox and I'm going to add a delete button, the problem is that the listbox selection skips over the 3rd row and the index count doesn't register the 3rd row and all the next rows it labels as four. I don't know where the problem is so I'll be uploading an example workbook because I don't wan't to assume where the issue is. I am using this nearly exact code in another book and nothing seems out of the ordinary. any help is much appreciated!
The listbox is showing what you are telling it to - the range A1:F8.
I don't see anything being skipped and any values in the listbox are taken from the range I mentioned.
If posting code please use code tags, see here.
When I scroll the listbox it skips a row in the spreadsheet and the listcounter stops at 4 but skips 3.
Sorry I worded that poorly, the highlighted selection in the listbox doesn't match the highlighted area in the spread sheet. when scrolled down through the list box, the highlighted area stops in the spreadsheet.
OMG... I figured it out, it's not counting duplicates... I had no idea it would do that.
The reason for that is the duplicate rows - Find is only going to find the first duplicate eact time.
Instead of using Find to get the row number on the sheet use the ListBox's ListIndex property.
say = ListBox1.ListIndex + 1 TextBox15.Value = say - 1 Sheets("PD Database").Range("A" & say & ":F" & say).Select
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
crowmagnus 
Register To Reply
Bookmarks