Auto Populate multi cells

[kmdmcr]

I would like to type a word into cell a1 and based off that word I want cells
b1 and c1 to fill in with specific text.

How do I program this?

Thank you

 

[carlo]

What exactly should appear in B1 and C1?
Do you want to do a Lookup of some matrix?

give some more information.

cheers

Carlo

 

[sebastienm]

hi,
You could create 2 UDF Worksheet functions in the book.

eg for the first one

Public Function FirstFunction(Param1 as Variant) as Variant
Dim strWord as string
strWord=Param1

''' do whatever with that string, eg: concetenate first and last letter
FirstFunction=Strings.Left(strWord,1) & Strings.Right(strWord,1)

End Function

Now, in B1, you can write : =FirstFunction(A1)