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

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top