Wildcard Search

[Faiek]

Hi,
I have this code to find a value in my worksheet.

Application.Index(Worksheets("Cross-Ref").Range("A12:A482"), Application.Match(Search.TextBox1.Value, Worksheets("Cross-Ref").Range("B12:B482"), 0))

Is there a way I can adjust it so that when a "*" is entered in Textbox1 it opens another userform with a combobox with all the possible values?

Thanks,

Faiek

 

[Alt3rnative]

Hi,
I have this code to find a value in my worksheet.

Application.Index(Worksheets("Cross-Ref").Range("A12:A482"), Application.Match(Search.TextBox1.Value, Worksheets("Cross-Ref").Range("B12:B482"), 0))

Is there a way I can adjust it so that when a "*" is entered in Textbox1 it opens another userform with a combobox with all the possible values?

Thanks,

Faiek

I Have a similar problem, is there anybody that would know how to implement this?

 

[Faiek]

Any Ideas, That You May Have on how to do this?