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