Create search form with checkboxes

Greetings,
I am now to this forum and programming in VBA
I have a spreadsheet which lists material information and has use locations and links to scanned images of documents.
Field names include:

MSDS number
PRODUCT NAME
TRADE NAME
MANUFACTURER &CONTACT INFORMATION
MSDS REVISION DATE
MSDS GHS Compliant? (yes or No)
Location1
Location2
Location3
Location4
USE
Obsolete?

I would like to create a form which would allow the user to search for the row(s) based on one or multiple locations which they would chose by a checkbox and then search in one of the other fields, e.g. product name or manufacturer.

In the spreadsheet there may be a variety of data types in the location column, I would like a return for all records where the column was NOT null or empty
Have the option to search all locations would be good too!

I would like the returned list to only show the locations checked but I could easily live with all locations returned.

One column contains yes/no, It would be nice to have the form be able to alter this field
Finally, In my sheet the field "MSDS Number" is hyperlinked to a scanned document, can the returned list include these hyperlinks?

I need some basic help to try to understand how to assign the control source to the form etc.

I would also like to limit the ability to change the data, will these forms work with locked data?

Thanks for any leads.
Dan

Just trying to bump this to see if this type of form is even possible in excel or if I am wasting my time trying. As I think about it, a form which filters the data would be best to allow changes.
Dan