language

  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. Y

    Userform UI Language Customization

    I have some userforms created in English, how do I code it such that using an option button, I can switch / change all the text to another language?
  3. S

    Search a table and return rows based on criteria of 2 cells

    Hello! I'm looking to search a table like the the one below. In a separate sheet in the workbook, I'd like to have the "Subject" as multiple columns and list underneath it all of the titles that match the subject and have the language in english. I tried working a combination of index and match...
  4. F

    building a traslator for the ancient language(eragon)

    hi i am working on a traslator for the ancient language from eragon i curently have a dictionary of 2530~ words and have created a version that works but you have to tell it the grammer of the word and it ignores sentence structure is there any one out there who has any idea how to convert...
  5. L

    Excel Version Compatibility Issues in VBA

    I developed an Excel VBA application on my Windows 10 Office 365 platform. My client is using Windows 8, Office 2016. Additional info: their PC language is English, with Japanese as a secondary language. My application crashed on their system. Symptoms: A formula...
  6. A

    VBA runtime error 5 with get Language

    Dear Freidns, I want to get the language code of the running Excel of the user. So I put this code: Sub scheisstest() Dim LNG_USERLANGUAGE As Long LNG_USERLANGUAGE = Application.LanguageSettings.LanguageID(msoLanguageIDUI) 'Worksheets("UI").Cells(45, 1).Value = LNG_USERLANGUAGE End Sub...
  7. A

    VBA - Mixed formats in column

    Dear Friends, I have a problem with a sheet: I have an extract from SAP made by my VBA. In the extract all columns are fine expect one column which is for quantities. If the vba opens the file, this column is already broken (please find attached example file). Only some cells are still...
  8. Jaafar Tribak

    "Cell" function accross Languages (No VBA)

    Hi dear members, I have this formula in a cell to return the name of the sheet where the cell containing the formula is located : =RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename"),1)) Now, if I open the workbook in an edition of excel other than English, the formula...
  9. K

    UI ribbon - can a macro change label after the ribbon is loaded?

    Hi, I have created an Excel template with a ui ribbon where user can select the language for the template in a dropdown. The language selection changes all titles and sheetnames accordingly but is there a way to change the labels of the ribbon groups, buttons, etc. as well so that a user...
  10. P

    Next Language for a Userform?

    I have been working within my company creating UserForms on excel for multiple different inputs and outputs. I'm getting the stage where I feel comfortable to move forward and create an actual program outside of excel. However, I am unsure of the best language for this. Currently I build...
  11. J

    Automatically update of secondary cell entry in cascading dropdown menu

    Hello, I have a list of price in 2 languages : French (FR) en English (ENG). Here is a model : <tbody> Please select a language Dropdown list 1 (choice : 'FR' or 'ENG') </tbody> <tbody> Object 1 50 Eur Object 2 100 Eur Dropdown list 2 (choice : 'maison' or 'avion' in FR / 'house' or...
  12. W

    Importing Text from XML to cell/Userform Textboxes

    Hi. I've got a excel program that i want to add 2 buttons, to choose which language the user want to use, so much question is this: Is it possible to add text in a xml file, and when i press language button "x" or "y", it loads the xml file for the correct language, and imports all cell names...
  13. T

    Using ArrayFormula with Spreadsheet Attached to Google Form Does Not Always Yield Correct Result

    I have a spreadsheet that needs to do X, Y, or Z (which are all various sums of columns of numbers) depending upon two variables: If A=5 and B<>0, then do X. If A=6 and B=0, then do Y. Else, do Z. I have a formula that works correctly without using ArrayFormula: =int(if(and(E2="5 courses each...
  14. D

    Change language only for Excel

    Hello there, I would like to set the display language for Excel to English (so I can write the formulas in English) but I would like to keep the other Microsoft Office programmes (Word and PowerPoint) in German. It looks like the Excel-language-options are bound to the Office-language-options...
  15. S

    Using VBA in other language excel file

    I am making an add-in and my excel has english settings, but my colleague has dutch settings in his excel. This is mostly not a problem, except for some worksheetfunctions I use: rounddown, min, max, averageif. Does any of you have a solution how to deal with this? Or are there any good...
  16. L

    which language excel was writtem

    Hi Which programming language was used to develop excel? how about the VBA? Thanks
  17. E

    language of Office for vba commands

    Hi I need to use this line of code: Range("A1").Select ActiveSheet.PasteSpecial Format:="text", Link:=False, DisplayAsIcon:= False The problem: When I use another computer with Office in another language (not English) the command is different ("text" in another language) and I get 1004...
  18. M

    Why would you recommend somebody to learn how to code in VBA?

    Hi! I don't know much about other "languages", but I think if it's about some kind of "data" editing, you can't find better language than VBA for your project. How do you see it? Is is true? In what aspect is VBA the best programming language ever? Thank you for your answer, I hope that...
  19. H

    Select Worksheet and then Reference

    Hi, I have a button that i want to add code to. When this button is clicked, a box will appear that lets the user select the worksheet they want to use. I then need to put language in similiar to ws='user slectected worksheet' so that i can import data from that worksheet. Thanks!
  20. V

    Associating a cell with a picture

    <tbody> I have an Excel sheet that calculates the positions of each country in a Group after placing the scores of each match for the 2018 World Soccer Cup in Russia. I have national flags corresponding to each country shown on the top of the 1st rectangle in the example and on column AC. The...

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