function edit()

I want to give sum of working time at Time Period from Date N1 to Date O1. formula writes in N2 Cell. This is Formula : =SUMIFS($J:$J,$L:$L,1,$B:$B,B3,$F:$F,$N$1,$F:$F,$O$1) what is problem answer is zero <tbody> <colgroup><col span="2"><col><col><col><col><col><col><col><col><col><col><col...

Hey Guys, I am very new to creating functions using Microsoft VBA and hence need your help for the same. I want to create a function which should perform the operation mentioned below. Function IDW(StartValue, EndValue, CurrentPoint) IDW = (StartValue * (Row(EndValue) - Row(CurrentPoint)) +...

"=MID(J2;FIND("@";J2)+1;LEN(J2)-FIND("@";J2)-(LEN(J2)-FIND(".";J2;FIND("@";J2)))-1)" I have made this formula to extract the domain from an email, i mean it takes anything after the "@" and before the final dot. What i want to do is to add this to an Add-in like a custom function i.e...

Hi I have an openform method in a form and I wish to have multiple where conditions however it is not working. This is the code that I have at present Function edit() Dim teama As String Dim clause As String Dim dat As Date teama = Forms![Edit_Entries_Form]![Combo5].Value dat =...