It is more efficient to use the built-in VB functions that reaching out to
the worksheet functions (unless the worksheet functions provide a
functionality that is not in VB and can't easily be coded for). Also,
sometimes it can be a pain to properly construct the arguments for the
worksheet functions from within VB. In any event, you can use the worksheet
function by using the WorksheetFunction property of the Application object.

--
Rick (MVP - Excel)


"jay dean" wrote in message
...
Okay, thanks Jacob and Rick! Is it possible to use the EXCEL functions,
"FIND()" and "SEARCH()" to achieve the same goal when dealing with a
combobox and a textbox?

If so, how will the statement be like? I am just curious !!

Thanks!
Jay

*** Sent via Developersdex http://www.developersdex.com ***