Hi all

I have searched and tried to use an article in the knowledge base but I get a "Compile Error - Automation result not supported in visual basic"...

article I used was http://vbaexpress.com/kb/getarticle.php?kb_id=344

anyway..have been asked if there is a simple way to produce an input box , that is permanently on the sheet for users to enter text/numerical strings to "find" data, rather than having to press Ctrl+F repeatedly....(the users are not excel proficient in any remote sense)

I wasn't sure...so any help would be appreciated..

PS Users will be using Excel 2000 or 97 (dependent on location)