TKT-Tang wrote:
3. Please show the alternative means of capturing TextFind by using
VBA code.

I think there is none.

You would do better to get the TextFind via an InputBox and then use it
in the Find method.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup