user created function

  1. S

    Customised UserForm

    Hi All, It would be of great help if I could get a solution for my long searching query. I have a Combobox in Userform which fetches the data from a worksheet, on selecting a specific record the rest fields would get auto populated, now the user has to fill few details in the available...
  2. 3

    Columns function - object-defined error

    Hi, I have the following procedure: Sub store_Dict() Dim key As Variant Dim myDict As New Dictionary Set myDict = CreateDictFromColumns("Sheet1", 1, 4) For Each key In myDict.Keys Debug.Print "Key = ", key, " Change = ", myDict(key) Next End Sub Where UDF CreateDictFromColumns is...
  3. Z

    Concatenate IF criterias are met VBA

    Hello everybody, I have the need to concatenate multiple values if certain criterias are met. I have a table that goes like this: <tbody> Color Mat Value Val2 BLUE X100 40 X BLUE D200 41 M BLUE X100 45 T YELLOW D200 30 S YELLOW HD2O 45 T RED X100 41 M...
  4. B

    Formula To User Defined Function

    Hi Guys, I was just wondering if anyone knows how to turn the below formula into a user defined function? for VBA =IFERROR(INDEX('Hidden Sheet'!B2:B19,MATCH(B7,Employees,0)),"") Many thanks Jamie
  5. T

    Named ranges with UDF's

    This is a repeat of an old thread which ended with an "it's impossible" verdict. I really can't accept that there is no solution so I am re-asking the question. http://www.mrexcel.com/forum/showthread.php?t=55657&highlight=named+array+udf Essentially I like to name rows and columns to make...
  6. Blammdon1

    VBA Returning a Range

    I can't find this anywhere on the net and it may sound stupid but, how do i return an actual range from a user created function so that another function say the MIN function can use that value to look at that range. (I mean like an actual Range, one that turns blue in excel not the values in...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top