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".