well if it was Sheet1 outside the brackets (the sheet with the named range in it I mean), then the code ought to work the way it is... you could try Worksheets("Sheet2").Range..... That is if the one with a tab name of "Sheet2" is the one with your named range.

Clng(me.EntClientIDBx.Value) converts the EntClientIDBx textbox to a Long data type... if it is not numerical you get the error. If you remove Clng, then because lvalue is dimmed as Long, it will still only accept numbers or give that error Type Mismatch.