How do I Evaluate a formula in a foreign language?2019 Community Moderator ElectionHow to style a <select> dropdown with only CSS?In Excel and VBA, how to set value of cell to the formulas result rather than the formulaFormulas within Named Range changes when opened in foreign langauge version of ExcelThe range in the Excel formula changes after insert-shift, how can I stop it changing?Find and correct all inconsistent column formulas with VBAConverting Excel formula to different locale/languageLanguage independent formulasFormula Sheetname combo dosen't workChanging a Worksheet Formula to a VBA formula with worksheet.functionUsing a user inputted formula in an Excel VBA function?
Do Paladin Auras of Differing Oaths Stack?
What is Tony Stark injecting into himself in Iron Man 3?
How can a demon take control of a human body during REM sleep?
Locked Away- What am I?
What is this tube in a jet engine's air intake?
Which country has more?
What will happen if my luggage gets delayed?
Why restrict private health insurance?
When to use a QR code on a business card?
What is the purpose of a disclaimer like "this is not legal advice"?
What does *dead* mean in *What do you mean, dead?*?
Converting from "matrix" data into "coordinate" data
Cycles on the torus
Graphic representation of a triangle using ArrayPlot
Professor forcing me to attend a conference, I can't afford even with 50% funding
How to educate team mate to take screenshots for bugs with out unwanted stuff
When an outsider describes family relationships, which point of view are they using?
What can I do if someone tampers with my SSH public key?
Why aren't there more Gauls like Obelix?
Create chunks from an array
Is there stress on two letters on the word стоят
(Codewars) Linked Lists-Sorted Insert
How to write a chaotic neutral protagonist and prevent my readers from thinking they are evil?
If nine coins are tossed, what is the probability that the number of heads is even?
How do I Evaluate a formula in a foreign language?
2019 Community Moderator ElectionHow to style a <select> dropdown with only CSS?In Excel and VBA, how to set value of cell to the formulas result rather than the formulaFormulas within Named Range changes when opened in foreign langauge version of ExcelThe range in the Excel formula changes after insert-shift, how can I stop it changing?Find and correct all inconsistent column formulas with VBAConverting Excel formula to different locale/languageLanguage independent formulasFormula Sheetname combo dosen't workChanging a Worksheet Formula to a VBA formula with worksheet.functionUsing a user inputted formula in an Excel VBA function?
I'm having some problems with some code and any help would be very appreciated.
I downloaded a code that enables users to have the autocomplete feature in dropdown lists. The code evaluates whether or not the Activecell contains a list and then stores the list as an object. The problem is that my users have the Spanish version of Excel, so the code doesn't work. Particularly, I have problems in this line of the code:
Set rFormula = Evaluate(ActiveCell.Validation.Formula1)
If rFormula Is Nothing Then 'VBA doesn't recognize the formula so rFormula = Nothing
End
End If
As ActiveCell.Validation.Formula1 = the formula but in Spanish. This code works perfectly in my pc because I use the English version.
Thanks again!
vba excel-formula combobox evaluate
New contributor
add a comment |
I'm having some problems with some code and any help would be very appreciated.
I downloaded a code that enables users to have the autocomplete feature in dropdown lists. The code evaluates whether or not the Activecell contains a list and then stores the list as an object. The problem is that my users have the Spanish version of Excel, so the code doesn't work. Particularly, I have problems in this line of the code:
Set rFormula = Evaluate(ActiveCell.Validation.Formula1)
If rFormula Is Nothing Then 'VBA doesn't recognize the formula so rFormula = Nothing
End
End If
As ActiveCell.Validation.Formula1 = the formula but in Spanish. This code works perfectly in my pc because I use the English version.
Thanks again!
vba excel-formula combobox evaluate
New contributor
Please share with us the formula, in English so we can recommend something for you.
– donPablo
Mar 7 at 0:43
add a comment |
I'm having some problems with some code and any help would be very appreciated.
I downloaded a code that enables users to have the autocomplete feature in dropdown lists. The code evaluates whether or not the Activecell contains a list and then stores the list as an object. The problem is that my users have the Spanish version of Excel, so the code doesn't work. Particularly, I have problems in this line of the code:
Set rFormula = Evaluate(ActiveCell.Validation.Formula1)
If rFormula Is Nothing Then 'VBA doesn't recognize the formula so rFormula = Nothing
End
End If
As ActiveCell.Validation.Formula1 = the formula but in Spanish. This code works perfectly in my pc because I use the English version.
Thanks again!
vba excel-formula combobox evaluate
New contributor
I'm having some problems with some code and any help would be very appreciated.
I downloaded a code that enables users to have the autocomplete feature in dropdown lists. The code evaluates whether or not the Activecell contains a list and then stores the list as an object. The problem is that my users have the Spanish version of Excel, so the code doesn't work. Particularly, I have problems in this line of the code:
Set rFormula = Evaluate(ActiveCell.Validation.Formula1)
If rFormula Is Nothing Then 'VBA doesn't recognize the formula so rFormula = Nothing
End
End If
As ActiveCell.Validation.Formula1 = the formula but in Spanish. This code works perfectly in my pc because I use the English version.
Thanks again!
vba excel-formula combobox evaluate
vba excel-formula combobox evaluate
New contributor
New contributor
edited yesterday
Nacorid
159112
159112
New contributor
asked Mar 6 at 22:48
Juan Alejandro Brito ArcilaJuan Alejandro Brito Arcila
1
1
New contributor
New contributor
Please share with us the formula, in English so we can recommend something for you.
– donPablo
Mar 7 at 0:43
add a comment |
Please share with us the formula, in English so we can recommend something for you.
– donPablo
Mar 7 at 0:43
Please share with us the formula, in English so we can recommend something for you.
– donPablo
Mar 7 at 0:43
Please share with us the formula, in English so we can recommend something for you.
– donPablo
Mar 7 at 0:43
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Juan Alejandro Brito Arcila is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55033425%2fhow-do-i-evaluate-a-formula-in-a-foreign-language%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Juan Alejandro Brito Arcila is a new contributor. Be nice, and check out our Code of Conduct.
Juan Alejandro Brito Arcila is a new contributor. Be nice, and check out our Code of Conduct.
Juan Alejandro Brito Arcila is a new contributor. Be nice, and check out our Code of Conduct.
Juan Alejandro Brito Arcila is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55033425%2fhow-do-i-evaluate-a-formula-in-a-foreign-language%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Please share with us the formula, in English so we can recommend something for you.
– donPablo
Mar 7 at 0:43