I am trying to write an Excel VBA function that will return one of two input parameters as the formula for the cell it is input in based on a global setting somewhere else in the sheet. IE, somewhere else in the sheet someone sets A or B, then formulas that call the functon AorB will return A or B based on what the global setting is.
Function AOrB(A As Variant, B As Variant) As Variant If someSetting = A Then AOrB.formula = A ElseIf someSetting = B Then AOrB.formula = B End If End Function
I've scrounged pretty heavily but I just don't have the knowledge of what types to input and return in order to allow the function to return.
Any help would be appreciated.Devbrat Tripathi
I am not sure why would you want to use a UDF or VBA solution for this scenario, knowing that we have excel built in functionalities to perform this operation.
You could either use Excel IF function or CHOOSE function to perform this operation provided the requirement is much more complex than it appears...
Appreciate if you could share a sample file along with the result required for us to assess the requirement and provide an efficient solution.Asheesh Mattoo 25 Feb 2017 1 0