user-defined functions

I currently am using a formula in Column J of Sheet 2 of my workbook that will look up values from 5 columns on Sheet 1 and return the corresponding text. For example if the value from column M on Sheet 2 matches any of the values from column J on Sheet 1 it would return "N", if not it would...

Hi, Excel 2016 rolled out many new functions such as SWITCH, TEXTJOIN, etc. Unfortunately, these functions are not available for non-365 subscribers. I was wondering if somebody built a VBA UDF for SWITCH already? Its syntax is the following: Syntax SWITCH(expression, value1, result1...

I have this Sub that I get exactly what I want, but I want to make it a function so the the "Team" Variable can be a cell that I select. Here is the Sub code. Option Explicit Sub MYCOUNT() Dim Team As String Team = Range("BC7") Dim rg2 As Range Set rg2 = Sheets(1).Range("C5:AR5")...

I have a large and reasonably complicated workbook, which uses UDF and macros to run a series of processes for analysis purposes. The file itself is 9MB, and this is without any data in it. The purpose of the workbook is that the user pastes a number of comments in Column B of the opening...

Using Windows 7 and Excel 2013. I'm trying to create a function to facilitate table top role-playing (i.e. Dungeons & Dragons). I want the formula to accomplish a randbetween for a specified number of times. I would also like the formula to be non-volatile (i.e. doesn't recalculate every time...

I manage to display the chm help file to an User-Defined Function by clicking on the "Help on this function" in Insert Function dialog box. This was possible only when the my file is xlsm. After I saved the xlsm file as an xlam file (an addin) and installed the addin. The help file can be...

I found John Walkenbach's tip on how to add argument descriptions to a user-defined function, but it does not seem to work for me. Spreadsheet Page Excel Tips: User-Defined Function Argument Descriptions In Excel 2010 After the 'description assignment macro' is run, the details become available...

I have a user defined function that I have written. It is designed to be used in a table in the rows that display certain results. Rows 1-4 of the table are header rows which contains constants (dates and values) that apply to the remaining rows of that particular column. Rows 6 thru n have...

I am trying to create a custom function that will be used on multiple different sheets. Depending on the data on each sheet, the custom function needs to calculate a few different ways. One of the inputs needed for the function to know what to do is "NumNewDiags". I currently have another...

Trying to classify businesses by a number of factors put together. I'd like to do this in a query; number of variable factors leads me to believe some of this needs to be a UDF in VBA. The classification system would be similar to the packages you can buy at a car wash (except pretend you can...

I created a user defined function that gives a text string of the year and the quarter based on the date. However, I can't figure out how to make this function available to all my workbooks. It only appears in the workbook I had open when I created it. Can someone tell me how to make it...