Error when run the code a second time without Re-opening the workbook

[gary lawrence]

Hi all,

If I open the workbook and run the below code, it runs fine. However if I run the form and run the code a second time without reopening the workbook, I get method add of object listrows failed. I have added the listbox resource to UserForm_Initialize, any ideas?

Please Login or Register  to view this content.

[mjr veverka]

Maybe upload some sample file ?

[gary lawrence]

Hi thanks for the reply, I have uploaded a sample file

[Sintek]

Do it this way...Rowsource...I find most times has a bug...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[beyond Excel]

Hello.
You are entering the data as follows:

Please Login or Register  to view this content.

However, you have to do it like this:

Please Login or Register  to view this content.

In short: when you have bound a list box (or combo box) to a range of data (in this case to a list object) via RowSource, ALWAYS unbind them first, enter or delete the data, and finally rebind them: will never let you down like this.

[gary lawrence]

Thank you everyone for your input It now works Perfectly

[Sintek]

Glad to have helped...Tx for rep +...
Any other questions regarding this...just post here

[beyond Excel]

Thank you everyone for your input It now works Perfectly

Thank you very much for adding reputation and I hope that what I suggested will be very useful to you.