MultiColumn Listbox populate with a criteria in column S

Hello to all,

As you already know I am new to this forum. I am a trying to run a userform which will be used by multiple users. My form is currently working properly but I need to make a few adjustments in coding which due to my lack of knowledge I am unable to. What I want is that each user should be able to see only what he enterted in the listboxt except the user "Admin" who can see all.

the name of my User form is frmReq and current user is in textbox=txtActiveUser. Currently my form is using "rowsource" method to populate the data so it is populating the entire range.

My data sheet name is "Requisitions" and listbox name is lstdatabase. It would be great if someone can help me through......

txtActiveUser gets its value from sheet "privacy page" range "H1".

Demo.zip

I am not using autofilter to load listbox….. i am using rowsource

Autofilter is being used for criteria searches only

already told you, the code you are referring to works to search from search box text box only. it is not populating at initialization. My query is that i need txtActiveuser textbox whcih is the active user to be as criteria and when form is initialized only rows having txtActiveUser value should be shown.

txtActive user value is being received from "Privacy Page" cell "H1"

Nice coverup….. u could just have told me you are not capable enough to resolve the issue….. u kept on emphasising on a point which was very politely responded….. no one forced you to respond in the first instance