Hi! Novice here hoping to get some help with making my userform.
I have a table with "Class1" to "Class 4" as headings and then some values under each one
I want to make a user-form that has a text-box and 4 check boxes "Class1"..."Class 4"
When the userform opens if the value in the text-box is in the table under any of the class column headings the corresponding check box is checked, if it is not, the check box for that class is empty.
the last part (probably the most difficult) is that When you click one of the check boxes it will add that text to the first empty row under that column heading. AND if you un check the textbox it will delete that value from the list and then shift the rest of the column's values up to keep from having an empty cell.
I'm really struggling with the coding, and a complete beginning so I would REALLY REALLY appreciate any help! Thanks!