House Size Bedroom Name
House Size Bedroom
First 1200 2
Second 4400 4
Third 1800 2
Fourth 1200 3
Fifth 5000 5
Sixth 1000 1
Name Type What
database Worksheet Where all the data is stored - both that original and that obtained from the user
output Worksheet Where all the output is going to show up
alldata Range The range for the database, on "database"
yourchoice Range The range for the user's preferences, on "database"
size Cell The cell for the user's size preference, on "database"
bedroom Cell The cell for the user's bedroom preference, on "database"
getinformationuserform Form To collect preferences from the user
sizelistbox Listbox Provides size choices
bedroomlistbox Listbox Provides bedroom choices
showcommandbutton CommandButton Runs macro to store user preferences and to filter database in user form - getin
exitcommandbutton CommandButton Runs macro to exit user form - getinformationuserform
nametextbox TextBox Obtains user name in user form - getinformationuserform
username Cell The cell for the user's name, on "database"
al and that obtained from the user
o filter database in user form - getinformationuserform