I am VERY new VBA programmer so I need some help. Below is my code. I cannot seem to get the items to add to my listbox. Below is what I found as code online as examples, but it doesn't seem to work. There are probably other problems as well, so if anyone has any suggestions, please, fire away!
Please Login or Register to view this content.
It also may help to know that I am getting 'Runtime Error 424 Object Required' when I run the code.
Last edited by mrapes; 06-08-2012 at 10:56 AM. Reason: more info needed
Hi
Upload your file where the listbox is present and also the data which you want to insert into the listbox with explanation....
Click *, if my suggestion helps you. Have a good day!!
Tr this
Please Login or Register to view this content.
Where's the code? Is it actually in the UserForm code window, it looks like you may have typed it in manually
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Here's a couple of examples how it should be done
I have attached the file I am using. All I am trying to do is place the values (additem) into the listbox. I tried both ways that you guys mentioned above & neither one worked for me. Thank you all for your help.
Hi
The code to fill in the listbox named "errorlistbox":
Please Login or Register to view this content.
I appreciate the quick reply. I try that & it still isn't working. Is it possible that there is something else causing the problem?
Did you bother reading my post or looking at the example that i took the time to attach?
Your code is in the wrong place
I did read your post & look at your example. I failed to notice the code I was missing at the top. I apologize. Your code works when I run it, but when I copy it into mine, it won't work on my userform. I don't see what the problem is.
I apologize for not realize what I was doing sooner. But I got the code to work by placing my code in two separate windows. I don't know why this was necessary, but it worked!
Any code that is a UserForm event code like the Initialize should be in the UserForm code window. You make sure that you are working with that buy double clicking on the UserForm in the VB Editor & selecting the event from the right hand drop down
That makes a lot of sense. Thank you again for all of your help. I really appreciate it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks