Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Populate multi cells
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Populate multi cells
What exactly should appear in B1 and C1?
Do you want to do a Lookup of some matrix? give some more information. cheers Carlo On Dec 28, 10:30*am, kmdmcr wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Populate multi cells
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) -- Regards, Sébastien <http://www.ondemandanalysis.com <http://www.ready-reports.com "kmdmcr" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I auto-populate cells on another sheet? | Setting up and Configuration of Excel | |||
can I auto-populate cells on another sheet? | Excel Discussion (Misc queries) | |||
Auto Populate Cells | Setting up and Configuration of Excel | |||
Auto populate cells | Excel Discussion (Misc queries) | |||
Auto populate cells based on 2 cells division. | Excel Discussion (Misc queries) |