Search for Partial Text

[grkchakri]

Hello All

I am trying to write a code for searching for partial text in a cell when user enters value through an input box function.
For example Cell A10 has a value for post code cell B10 should show the respective country as below

CELL A10 : AB1 CD2
CELL B10: USA

CELL A10 : UK1 EF2
CELL B10: UK

CELL A10 : IN1 GF2
CELL B10: INDIA


So if cell A10 has value starting with AB/UK/IN it should show the respective country . no matter what the other part of the text is.
can we do this through search/find/match options on VB . How to write a code for this and whats the best way do it



Thanks for u r time

[kvsrinivasamurthy]

To find Text Starting with AB use the below code.

Please Login or Register  to view this content.

[grkchakri]

But how will that give the value in b10

[kvsrinivasamurthy]

To get B column value add this code after that.

Please Login or Register  to view this content.