Listbox Issues / Errors with UserForm

I am having a few issues with a userform attached. I would first like to thank Roy UK for the link to the VB and website http://www.excel-it.com/vba_examples.htm this has helped me out no end but I have a few issues that I have tried to solve but have come up against walls all over the place.

1. ListBox1 – if there is any more then 1 record found then I keep getting errors unless I have remove .TextBox10.Value = ListBox1.List(R, 9) upwards.

Please Login or Register  to view this content.

2. After removing .TextBox10.Value = ListBox1.List(R, 9) upwards I then get the following issues.
a. It only deletes the record at the top of the list and not the one that is selected
b. How to make the ListBox columns narrower.
c. What code is needed to clear the ListBox.

I would appreciate all the help that anyone can give me.

Hi Chris270

This is my first attempt at using ListView Controls so we may struggle with this approach. I was introduced to ListView by Leith Ross in a Thread I was following.

The attached has the ListView Control in place of the ListBox Control. Play with it...let me know issues...perhaps this'll work for you.

Hi Chris270
It'll be a bit before I get back to you...with Forum issues and the Holidays. I WILL get back to you.

Hi Chris
I've attached a file that I presume is the one referred to.

John, Kyle123

Many thanks I will take a look and get back to you. Have a great Christmas and an even better New Year.

In this case I would copy & paste the found items to temporary sheet then use the new list as the RowSource for the ListBox

Replace the FindAll Procedure with this

Please Login or Register  to view this content.

Roy UK,

Thanks for your assistance i have added the code and removed the old code, however I am getting the following issue:

Run-time error “Could not set the RowSource property. Member not found.”

jaslake,

I am still having issues with the following:
- Saving changed data (it saves it in the top listed person and not the one selected)
- Deleting data (it deletes the top listed person and not the one selected)

Please start at the beginning:

Please Login or Register  to view this content.

und dann:

Please Login or Register  to view this content.