vb drop down menue

hi i have a problem trying to show data from a excel file up into a dropdown menue in vb, the problem is that it works ok when the selected woorksheet is selected in excel but when in another excel worksheet the data does not show up in the dropdown menue.

sSheet = Application.ActiveSheet.Name
lCaseRow = ExcelRowExist(tb_Case.Value, sSheet)

cb_EscTeam.Value = Cells(lCaseRow, 14).Value

i think here where the problem is "ActiveSheet" i tried

ssheet="NameOfSheet"
lCaseRow = ExcelRowExist(tb_Case.Value, sSheet)

cb_EscTeam.Value = Cells(lCaseRow, 14).Value

but the same problem, any1 with any ideas?

never mind i got it.,ta.