Hi all,

I have created a text box within a userform and I have the following
problem.

I wish to enter a surname into the text box, click a Find control
(that I have also placed on the userform) and search through a column
of cells in a worksheet and locate the surname that I have entered
into the text box.

For example if I enter 'Smith' into the text box, I wish for it to
locate, and stop on each 'Smith'.

After having done the above I would like to take it a step further and
use the star (*) wildcard with the search.

For example if I enter Sm* into the text box, I wish for it to locate,
and stop on each 'Smith', 'Smyth', 'Smithson' etc - that is, all the
records that start with 'Sm'.

Likewise, if I enter *ones into the text box, I wish for it to locate,
and stop on each 'Jones', 'Simones', 'Carones' etc - that is, all the
records that end with 'ones'.

Thanks again for your help