Need to use partial text to lookup data in worksheet using a text box or combo box or both

**Mark Dynes** · 03-15-2017, 11:58 AM

Hi Guys,

I need to be able to search for partial text in definable columns in a worksheet, using a user form textbox or combo box. I have attached what I have already but I can only get it to work if the exact match is found. Please help, thanks!

**dangelor** · 03-15-2017, 01:19 PM

Possibly the look up variable to include wildcard characters...

    theValue = "*" & Me.ClntNme.Text & "*"

**Mark Dynes** · 03-15-2017, 01:57 PM

I'll give that a go thanks dangelor.

**Mark Dynes** · 03-15-2017, 02:10 PM

That has worked, Thank you dangelor, Much appreciated!!!

**dangelor** · 03-15-2017, 03:36 PM

Happy to help!

Need to use partial text to lookup data in worksheet using a text box or combo box or both

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Need to use partial text to lookup data in worksheet using a text box or combo box or both

Re: Need to use partial text to lookup data in worksheet using a text box or combo box or

Re: Need to use partial text to lookup data in worksheet using a text box or combo box or

Re: Need to use partial text to lookup data in worksheet using a text box or combo box or

Re: Need to use partial text to lookup data in worksheet using a text box or combo box or

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to lookup a partial text string

Partial lookup from text string, return value from lookup list

Partial Text String Lookup from a List

[SOLVED] Lookup with partial text match

Lookup partial value and return text I define

[SOLVED] Partial text lookup

Bookmarks

Bookmarks

Posting Permissions