excel help

Hello, vampyr07au.

I hope you will find the following information helpful.

Yes, there is a problem with the design of the forms that is causing them to act differently than expected.

In the Input Details screens, the Year, Genre, and Rating fields are all ListBox controls. ListBox controls normally require the user to actually click on the chosen item in the field to select and highlight the item before the application can process the data. If you click on the up or down arrows, and don't actually click inside the field to highlight it, it won't work.

I believe that using ListBox controls that only show one item at a time, like they do in this application, is not the best way to present this type of data. I think it would be more user-friendly to make the Genre and Rating fields ComboBox controls, like the Actor fields, and make the Year field an ordinary TextBox.

Yeah I got that sorted .... now I just need to figure out how to do everything else I want lol.

What's the code that will keep the lists sorted in alphabetical order at all times and where should I put it ?

Is there a way to make the view all button display all the movies in the excel spreadsheet form rather than in a user form?

I would like to be able to actually have a database that can be used by other people in my family so we can all see what movies each of us have as we all like to borrow movies from one another. The way I thought to do this is to add checkboxes in the input forms that would be checked when a movie is entered and would then generate a select of some form in a column in the spreadsheet. ie: checkboxes that have: "mom", "brother" "uncle" etc and a column for each of these people in the spreadsheet that when the checkbox is selected on the input form it places a yes in the corresponding colummn .....

Is there a way to make this database as an exe file so it runs as dbl click from desktop?

My other concern is that when we all swap databases between ourselves if they are named the same thing then they will overwrite when i download "brothers database" from my emails and while I get all his new movies I will lose any of mine that have been added in recent times. Is there some way that we can have something that can be run that will check data between spreadsheets and add new entries to each so that they are updated?
ie: have "my database" and then "brothers database" is emailed to me and I can compare them both and make them the same.

Hope all this makes sense.