VBA - How To Extract A Value From Cell In Non-activated Worksheet

I found something similar here VBA - How to select a range in a non-activated worksheet but when I tried to "apply" it, I kept getting an error if the relevant sheet wasn't activated. My code

Code:
Dim SearchRange As Range, FindRow As Range
Dim column As String, search_string as string
column = "K"

[Code]...

What I want to do is to be able to search for a specific value in a specific column on the "Combo boxes" sheet, which isn't activated (the number of rows will never be large, thereof the hard-coded 200).

I get the impression that some sites say the relevant sheet has to be activated, others say it doesn't.

The code above works fine if the sheet is activated, otherwise it fails with error 91 on the msgbox row.