How to call a function in module from sheet in VBA

Hello,

I have a code in module and I want to call that function from "code on Sheet".

Using below method, it works. But its creating an other problem, its not highlighting the cells on sheet, user will not know which cell is he working on.

Code on Sheet

Please Login or Register  to view this content.

Code on Module

Please Login or Register  to view this content.

Please Login or Register  to view this content.