Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can one write one's own Excel Function?
Can one write one's own Excel Function?
For example, suppose I've got calendar dates in one column, and I want to translate them to Italian in another column. The Italian translation should change automatically when I change the calendar date. The "Italian column" would be coded something like =Italian(F3). Is there any way to do this? - Elliott Baral |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
can one write one's own Excel Function?
Elliott,
Yes, just call the procedure Function instead of Sub. A simple example is Function inc(rng as Range) if rng.Count 1 Then CvErr(xlErrValue) Exit Function End If inc= rng.Value + 1 End Function -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Elliott Baral" wrote in message ... Can one write one's own Excel Function? For example, suppose I've got calendar dates in one column, and I want to translate them to Italian in another column. The Italian translation should change automatically when I change the calendar date. The "Italian column" would be coded something like =Italian(F3). Is there any way to do this? - Elliott Baral |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
can one write one's own Excel Function?
Yes, of course. For example open VBA, insert a module and then insert this
in the module Function french(myword) Select Case myword Case Is = "oui" french = "yes" Case Is = "merci" french = "Thank you" Case Else french = "Beats me!" End Select End Function "Elliott Baral" wrote in message ... Can one write one's own Excel Function? For example, suppose I've got calendar dates in one column, and I want to translate them to Italian in another column. The Italian translation should change automatically when I change the calendar date. The "Italian column" would be coded something like =Italian(F3). Is there any way to do this? - Elliott Baral |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SOS! how do I write a customized function to do multiple-value lookupin Excel 2007? | Excel Discussion (Misc queries) | |||
Is there a write-multi-cell-at-once function in VBS for Excel? | Excel Discussion (Misc queries) | |||
Pleeze Help! Export Excel data into a form in a Word Doc...this one's tough! | Excel Discussion (Misc queries) | |||
How to write IF function in Excel 2000 when there are two conditi. | Excel Worksheet Functions | |||
Write a function call into an Excel cell from VBA | Excel Programming |