Good Morning everyone.
Yesterday I got help on filling a listbox from here and the problem was solved with all the great help I got, snb told me I wouldbe better off with a Combobox instead of a listbox. I changed the listbox to combobox with the new code and it only fills in one row. I'm I doing something wrong or will the combobox only fill one row from list. Looking to fill row 3,4. form2 is the one I'm working on.
Thanks
Last edited by zplugger; 02-10-2011 at 01:43 PM.
The Combobox seems to fill Ok. Why are you using a Multicolumn ComboBox. What exactly do you want to display in the second Combobox
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I was hoping for Location, Actors in Combobox2.
Then use a ListBox, I'm sure that you can't display 3 Columns of a ComboBox
Isn't he filling the second combobox from the first combobox list?
Should he be filling the first combobox with Sheet2 Column A(movie) and then filling the second combobox from Sheet2 Columns C(loc) & D(actors)?
Life is like a roll of toilet paper. The closer it gets to the end, the faster it goes.
John Wright
I'm not really sure why he has taken this approach at all
just from suggestion, I will return too listbox. Thanks
Can you clear up what the purpose of the userform is? I saw your original code yesterday & it was way overcomplicated
Hello royUK, the purpose of the userform is to search the database and find a movie and show location and what actors are in it. The form I post is a example of what I want. The listbox works ok except it stays highlighted when a movie is found,which is no big problem. The lookup actor form works perfect, just trying to have a form to lookup movie and work the same as lookup actor. I know you guys are experts on this stuff and I'm a newbe with little knowledge on this. I have gotten a lot of great help from this site and you guys are he greatest. The form will work ok for me, thanks again for all your help. One reason I went to a Comboxbox instead of a listbox was the combobox did not stay highlight aftem a movie pick.
Z
Z,
Take a look at this and see if this would work any better for you. I modified your Userform2 just a little bit and used two seperate textboxes vs the combobox2.
I also edited the code on UserForm2 to load the combobox when the Userform loads and associated the Number and Actor in the row for each Movie.
......pick a Movie out of ComboBox1,
..... then the Number from Sheet2 Column C and the Actor(s) from Sheet2 Column D show up in the two textboxes for you.
Thanks for your time jwright650, I like this idea. The only thing I see is if the boxes are filled with data and you type in a new movie it does not change the lower boxes auto.
Here is another idea....deleted the actor textbox and have both Number and Actor appear in the single textbox....change the movie the actors change with it.
Thanks again I like this too, The only thing is if a movie is pick and you change it does not fill the lower box auto. Lets say american pir has filled the data boxes, if I type in bait it does not auto fill the lower box. Thanks for taking your time for helping me.
Are you hitting enter after you type in the new movie? If you use the drop down arrow in ComboBox1 and choose the movies that way, it updates automatically...at least on my machine it updates instantly.Originally Posted by zplugger
Ah...I see what you mean...I was choosing from the drop down arrows and it updates instantly, if you type in the movie, you have to click the combobox for it to update the textbox info. I think it is due to the clickevent code for the ComboBox1. Not sure how to fix that.
Hi John
If I use the arrow it works perfect, use the arrow and load the movie bait. After it is loaded type in american pie, it does not update the lower box on my machine.
Hmm, I'm not sure why it works for me and not you.....I need to read up and see if I can figure that one out.
You seem to just make your code unnecessarily complicated, why aren't you using snb's code that he suggested before you changed to a ListBox?
Problem Fix, I'm using John's code and it works perfect after I change the ComboBox1_Click to ComboBox1_Change. Thanks for all your help guys on this.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks