1. A

    Translate function VBA

    Hi all, After trying various VBA scripts I am stuck as none of them worked. I am looking for a VBA function which will allow me to translate a cell and output translation to another cell. So for example if cell A1 had some text in Dutch, then if the function was used in B1 to translate to...
  2. Z

    Countifs into SUMPRODUCT

    =CountIFS('[Direktgeschäft VU - 2019 NeU.xlsx]Daten '!$A:$A;">="&'[Direktgeschäft VU - 2019 NeU.xlsx]Daten '!$A$1684;'[Direktgeschäft VU - 2019 NeU.xlsx]Daten '!$J:$J;B19) Could anyone please help me translate this into a SUMPRODUCT ?
  3. N

    Translate Excel Function to VBA

    Hi, Can someone please help me translate this function to VBA? =IF(G5="Delivery",(10000+IF(D5="Ain Jarfa",1000,3000)),10000) I need it in Sub cmdNew_Click as: ws.Cells(nr, "I").formula = (The above function) Note: Instead of "G5" put (ws.Cells(nr, "G")) Instead of "D5" put (ws.Cells(nr...
  4. Z

    Sumifs does not work when a workbook is closed

    =SUMMEWENNS('[Direktgeschäft VU - 2019 NeU.xlsx]Daten '!$C$2:$C$1703;'[Direktgeschäft VU - 2019 NeU.xlsx]Daten '!$J$2:$J$1703;B19;'[Direktgeschäft VU - 2019 NeU.xlsx]Daten '!$A$2:$A$1703;F6) as well all know whenever i close the other workbook it gives #Value, can anyone help me to translate it...
  5. K

    Translate formula into vba (index match and if formula)

    Hi I need help here, do anyone know how to translate the below formula into vba IF(LEFT(K5,1)="#",0,MAX((L5-INDEX(WorkingHrs[To],MATCH(J5,WorkingHrs[Working Hours],0))+(L5< index(workinghrs[to],match(j5,workinghrs[working hours],0))))-index(workinghrs[hours],match(j5,workinghrs[working...
  6. M

    Convert Excel to Vba Code msxml2.xmlhttp

    The code I wrote is also slow to take data from the site so I want to translate it to msxml2.xmlhttp. I need your support for it, if you help <svg focusable="false" xmlns="" viewBox="0 0 24 24"> </path></svg><svg focusable="false"...
  7. T

    VBA for Business - Search across 2x pages with Transposing of Information

    I have a Excel document made up of 2 worksheets - one entitled "Support Register' and the other entitled 'Services' On the support register sheet, we have every client in Column B from Rows 9:120, and all our services across the top in Columns B8:ZZ8. I am attempting to make it so when I...
  8. V

    I NEED HELP for translate index/match function into vba code

    Hi, anyone please me save :(:( how do i translate this to a vba code =INDEX('16090540'!D2:D296,MATCH(MAX('16090540'!N2:N296),'16090540'!N2:N296,0)) what i have done is test =...
  9. T


    Hi, can anyone explain me how to translate this formula excel into VBA? =SUMIFS($H:$H,$A:$A,$A2,$B:$B,$B2,$D:$D,$D2,$E:$E,$E2) Thanks in advance for your help.
  10. J

    Translate an embedded Excel formula in vba for Excel

    Hi folks, Could anyone help me translate the following Excel formula to VBA...
  11. H

    text to date

    Hi, is there some formula to translate text stored like this "28. June 2018" into date? Thx
  12. R

    Translate sequence of numbers to another sequence of numbers

    Hi I need to translate a seuqence of numbers 01000988 to another sequence format, 0010-01-0988 were the part 0010 is matched to the first four symbols of 01000988 the 01 is just Always 01 and 0988 should match the last 4 of 01000988 this is what I want the results to be 01000988 =...
  13. D

    Speak XML dictionary

    Good day this use to Translate Languages CreateObject("MSXML2.XMLHTTP") how to be used for Speak language Tanks
  14. Dazzawm

    Translate Spreadsheet

    Is there a code I could run that would translate an entire spreadsheet from French to English please?
  15. V

    Translate Worksheet to different language

    I have created a quote builder for our organisation which is in English and like to be able to translate the quote (which can be dynamic) from English to Portuguese using VBA. I don't want to use google translate as it involves a cost and the spreadsheet requiring conversion has formulas and...
  16. S

    Translate (PRODUCT(1+A1:A3/100)-1)*100 Formula

    An existing spreadsheet has a formula which needs to be implemented in SQL. The user note indicates 3 months compounding formula where each rows stores 1 month of data. (PRODUCT(1+A1:A3/100)-1)*100 The formula does not have curly braces around it to make it an array formula. I tried to...
  17. M

    Function Translate extrack “DIV”

    ****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;"> <tbody style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit...
  18. S

    Translate words or phrases / texts

    Good morning. I would like to translate words or phrases / texts as it is possible to do with the google translator by setting the basic language (column a) and the languages to use for translation (column b) by entering the words or phrases (base language) in the cells from cell c1...
  19. B

    Translate this code to worksheet_calculate listener

    Hi, Im looking to translate this code into the worksheet_calculate listener as advised by members, however my lack of vba knowledge is getting the way. Is there anyway that can rewrite this code so it works in the calculate listener. Thankyou in advance!! Private Sub Worksheet_Change(ByVal...
  20. J

    Translate Timer Formula To VBA

    Hello: I have what has turned into a complicated, but nice workbook, at least for our purposes, thanks to some direction from all of you. It is a project plan workbook with a GANTT chart that is pulling from 2 SQL databases and 4 other workbooks located on the network to update all of its...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...