Read text file to ListBox and Delete rows in ListBox and re-write text file

Hi,

I am trying to read in a text file to a ListBox and have the ability to delete a row or rows in the listbox and then re-write the text file with the changes. Here is my code that works, but sometimes it deletes the very first row instead of the one I selected from the listbox, but not always. I must have something wrong with my code....

Please Login or Register  to view this content.

Thanks for any help you can provide!

tigeravatar ... thanks for responding. Attached is my file. The text file I am reading is just a simple line by line history log file with a time stamp. I want to be able to click on a line in the listbox and delete just that line and then update the text file. I have seen this do strange things, sometimes it deletes the one I select and other times it deletes the one I select AND row 1 and 2.

Thanks for any help!

Norie,

Thanks for responding... I just attached my file. I have been testing various pieces of code and have gotten very similar results.

This is really making me crazy I think... I am trying this, but it will just clear the entire listbox

Please Login or Register  to view this content.

There's no data.

No data where?

In the workbook that you attached.

It's kind of hard to help with nothing to work with.

All the data is in the VBE. The portion I am having trouble with is reading a text file from "C:Temp" to my UserForm Listbox and then updating the text file with the contents left from the listbox.

Text File looks like:

Please Login or Register  to view this content.

Read that into ListBox and delete the last line "Line 4" but the code just deletes all lines.

The only data in the VBE is for the Assembly combobox.

Please Login or Register  to view this content.

If the data for the listbox is in a file, can you attach that file?

I will have to check the file when I return home and re-post it. My problem is I cannot read even a 2 line text file and delete line 2 in the listbox and then re-write the text file with line 1. It seems to clear the entire text file and returns "Null"

It sounds like the problem could be with the reading/writing from/to the form.

When/where is the listbox populated?

There is a sub called cmbNotes_Click which has code to populate the listbox, apparently from a file, but there's no control called cmbNotes.

I think you are right... I will play with this more and re-post. I guess I'm just not sure how to update a text file from a listbox.

Ok, I got this working to be able to delete the last line of the text file and it seems to be re-writing the text file properly. The only problem with it is that I cannot select a line, which is what I would really like to do. Here is my code:

Please Login or Register  to view this content.