How can I write an entire VBA code that mimics the function find in excel? If any one could help me I'll be very grateful. its an assignment i have been given at uni and i have no idea how to do it as i am new to VBA

Hi

VBA has a cells.find function that has all the parameters, for example, search part of cell, search whole word, case sensitive etc.

You can create a userform and pass the values to Find function

Have a nice time

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)