user defined function

Hello, I would like to create a user defined function that will replicate the following logic: =If (top cell in this column=cell in a named range, "yes","no") Is this possible? Any ideas? Thanks!

Hello everyone, I am familiar with a few coding languages, including PHP, C++, etc, however I am new to Excel and VBA. I am attempting to create a do-while/do-until loop which stays in the same column, and keeps descending row to row until it hits a Gray-filled cell, at which point it takes...

Are there any built-in functions which allow me to define a custom number format as a parameter? Failing that, is there any way of creating a user defined function that contains a "format_number" parameter in the same way that the TEXT function has a "format_text" parameter? I have a large...

All- I'm really jammed up on this one and need urgent help for a project due today. I have a very large workbook that stores all of our currency information. Basically I need to be able to get a currency exchange rate from a table and run some sort of calculation with that rate. So for...

Hi- I have a UDF in one of my workbooks that is called when it shouldn't be. I don't think it is causing any errors (yet), but it is def slowing down my macro. Any thoughts are appreciated. Here is the UDF: Public Function CFwd(dtEnd As Date) '-- Return the last working day of the current...

To Modify UDF Function word Dear The VBA coding given below change numeric value to word. But if the numeric value is 1. "24674", it changes into "Twenty Four thousand Six hundred Seventy Four", 2. "324674", the function changes it in "Three hundred twenty four thousand six hundred seventy...

I'm a newbie with VBA. I've tried writing a user defined function : Public Function SplitNames(NamesCell As Range) Dim vecNames As Variant Dim cell As Variant Dim yourPcge As String Dim tmp As String vecNames = Split(NamesCell.Value, ",") For Each cell In vecNames...

Hi all. I have found a UDF online that does what I need it to do, but I am not sure how to make this function available on all workbooks I open. I know the workbooks will have to be maco enabled, but even upon opening a macro enabled workbook my UDF will not work. Will I have to copy and...