language

Hi all, I'm preparing a presentation and have written a lot in Word (with a couple of bits from ChatGPT). Whenever I paste the info into PowerPoint it changes the language of the text box from "English (United Kingdom)" to "English (United States)". This happens when I paste from anywhere...

https://www.mrexcel.com/board/threads/create-fill-in-the-blank-sentences-with-xl.239288/ Hi there, The macro above works fantastic for English text, but I am unable to get this to work with Japanese text. I am hoping this macro may also be used for French text. The desired output would look...

Hi, I have this formula: =(PROPER(TEXT(TODAY();"[$-809] ddd d/mm/jj"))) which is initially a Dutch language formula (hence the "jj" and the ";"), but I wanted to return the days in English so I added the locale code 809. The formula works perfectly on my work computer (Excel 2016 32-bit) but...

Hi there, What language are Excel formulas/functions written in? I refer to the formula bar, rather than the VBA. I guess this language must have some sort of a name. Thanks.

Hi Guys, Small issue yet annoying: I use Excel/VBA in different languages and I'd like a solution where I run a VBA code and display language updates automatically (let's say from English to German). I'm talking about this setting in Excel: I assume it can be done with some API or editing...

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

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?

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

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

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

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

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

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

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

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

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

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

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

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

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