Hello gents,
Im having some problems when updating my listbox cause when I do so, all the data repeats and repeats on each click I do on the "Update boton"
I have attached the file Im working on.
If you just run the userform and click the boton "Update", you will see how the listbox copy twice all the values.
Could someone help me on this?
I really apreciate the help
Thanks, regards
Last edited by pezalmendra; 08-18-2012 at 03:51 PM.
Good evening pezalmedra
I couldn't see an "Update" button on any of the formsOriginally Posted by pezalmendra
.
However, you can use a clear instruction, before repopulating your list box, thus :
HTH
Please Login or Register to view this content.
DominicB
I couldn't figure out where the problem is, so I will speak in general. If you have an event that adds items to the list box, perhaps you should first delete the listbox, then run the code. Just a simple example:
If you need more help, can you point me exactly where your code is to load the listbox and I will try and help?Please Login or Register to view this content.
Hi,
I attach the new file.
If you press the "Run" botton the userform will pop up. After that try this:
- Press Edit botton
- Change any value from a textbox
- Press Update
You will see how all the lines that where already on the listbox appears again underneath of the old ones. This occurs each time you press Update.
Thanks a lot for your attention. I appreciate it
Regards
I think BigBas is right
try this
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Excellent!!! Like always, thanks a lot guys
Oops sorry once again... just something I have noticed that I didnt realize it was happening:
Each time I press the boton "Insert Trip", a new trip starts in the UserForm and its to be filled in. Once you have introduced the information in the textboxes you want you then press "Update" and the data is stored in the Listbox. Everything OK up to here.
The problem comes when you delete all the trips from the ExcelSheet "Hoja1" and you start from the beggining inserting data through the userform.
I have attached 2 files:
- One of them if data already stored (works perfect)
- One with no data stored (doesnt work)
Thanks again, I appreciate the time you are taking on this.
pezalmendra
Last edited by pezalmendra; 08-19-2012 at 02:29 PM.
Hi!
Any idea about it?
Regards,
Hi Pezal,
I took a look at the code, and although I'm not 100% sure what I was doing, I think that I identified the problem. The code that you were using to identify the last row of data would not work if there is not data. It wasn't throwing an error, but it was not effective. I modified the Nuevo_Click code to check if there exists any data. If not, it sets the code to 1, otherwise, it adds on. Try replacing your Nuevo_Click code with the following and let me know if it works.
Please Login or Register to view this content.
Bas youre a genius!!
Its working as I wanted to!!!
Thanks a lot like always! I really appreciate all this help.
How do I put a star on this?
Regards!
Great! I'm glad it worked
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks