Hi all,
I've been fooling around with VBA in excel for the past few weeks. I don't have much programming experience, but I've been doing a lot of copying and pasting (from this forum in fact, so thanks!)
Here's my problem. I have this spreadsheet with about 250 different movie titles in column A and then various information about the movies in each respective row (producer, director, etc). I also have a form in which there is a combobox which has the titles for each project and when I scroll through it fills in the rest of the information instantly.
The form has been working beautifully, except when I have two titles that are identical it causes all sorts of problems, mostly with scrolling. I scroll through the list and when I get to the two projects in a row it stops scrolling. There are some other problems that arise but I think if I can fix that it will fix more things.
Anyone know how to deal with this nicely?
Thanks!
-Sam
I've been fooling around with VBA in excel for the past few weeks. I don't have much programming experience, but I've been doing a lot of copying and pasting (from this forum in fact, so thanks!)
Here's my problem. I have this spreadsheet with about 250 different movie titles in column A and then various information about the movies in each respective row (producer, director, etc). I also have a form in which there is a combobox which has the titles for each project and when I scroll through it fills in the rest of the information instantly.
The form has been working beautifully, except when I have two titles that are identical it causes all sorts of problems, mostly with scrolling. I scroll through the list and when I get to the two projects in a row it stops scrolling. There are some other problems that arise but I think if I can fix that it will fix more things.
Anyone know how to deal with this nicely?
Thanks!
-Sam
