Convert Excel formula to VB

[adriaandl]

Hi,

I am new to VB and would like to know how I can change my excel formula to VB?
this is my formula:
=IF(A3="Telkom","TGE",IF(ISNUMBER(SEARCH("mobile",A3)),"MOB",IF(ISNUMBER(SEARCH("ambulance",A3)),"TSC",IF(ISNUMBER(SEARCH("toll free n",A3)),"TSC",IF(ISNUMBER(SEARCH("toll free p",A3)),"TSC",IF(ISNUMBER(SEARCH("telkom spec",A3)),"TSC",IF(ISNUMBER(SEARCH("telkom univ",A3)),"TNG",IF(ISNUMBER(SEARCH(" e toll free",A3)),"TNG","OLO"))))))))

Any help is appreciated.

Adriaan.

 

[RCBricker]

sorry was in a meeting. so yes that is the solution to the header question.

glad I could help

rich