Runtime error 1004 - Autofilter method of range class failed

Hi All

I have a workbook with 3 sheets - Employees, Covid Tests, Anti-Body Tests

I've added some activex text boxes to the Employees sheet so that the end user can search/filter the list as they type

Sheet1 - This code works fine

Please Login or Register  to view this content.

But then I've tried to implement a similar thing on the 2 remaining sheets for test results, so that when the employees table is filtered to a single employee, their ID number is carried through to the test results sheets and these sheets will then also filter to only show results for that one person

But I'm getting a run time error on the 2nd line when using this code on sheet3 and sheet4

vba.png

Run time 1004.png

I think the problem lies with what sheet is active.
If the code on sheet3 or sheet4 is triggered while sheet1 (Employees table) is active, it produces the run time error

But if I'm on sheet3 or sheet4 and trigger the code manually (by typing numbers in cell C3) the code executes no problem

Is there any way to get around this?

Many thanks in advance
Vicky

How are you changing the contents of a textbox on a different sheet to the active one?

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)