Good day,

I have the following userform that has 1 combox and 5 textboxes – I use this to search through a data sheet (which works fine) however I want to add a checkbox to the userform that once checked then you are only able to search through the “true” (which I have a column true or false) column “G”. I will add a password to this checkbox, so that not everybody would be able to view all the enters. This is the current code.

Please Login or Register  to view this content.
The code below is what I think it should be, but also not sure where it should go Priavte Sub ComboBox1_Change() or Private Sub UserForm_Initialize()

Please Login or Register  to view this content.
Thank you