Pull the value of one cell into a userform based off another The Next CEO of Stack OverflowHow to find a value in an excel column by vba code Cells.FindHow to avoid using Select in Excel VBAExcel find & replace cell contents based on contents of a list in another sheetPass UserForm textbox value to cellwith a VBA userform, how do you populate a combobox with a different text and value?Input values in Excel sheet through userformRestrict Userform responses to values in specific excel cellsVlookup on value given in textbox1 & textbox2 & return value in another testbox3 from sheet2excel vba columns to listboxPopulate TextBox with cell reference when cell is clicked while UserForm is openFill VBA UserForm TextBox with variable cells based on TextBox Name
How do I go from 300 unfinished/half written blog posts, to published posts?
Return of the Riley Riddles in Reverse
Explicit solution of a Hamiltonian system
How to write the block matrix in LaTex?
Why did we only see the N-1 starfighters in one film?
What makes a siege story/plot interesting?
How to start emacs in "nothing" mode (`fundamental-mode`)
Where to find order of arguments for default functions
How to safely derail a train during transit?
Can the Reverse Gravity spell affect the Meteor Swarm spell?
Is it a good idea to use COLUMN AS (left([Another_Column],(4)) instead of LEFT in the select?
What is the difference between "behavior" and "behaviour"?
Rotate a column
How long to clear the 'suck zone' of a turbofan after start is initiated?
Implement the Thanos sorting algorithm
Unreliable Magic - Is it worth it?
How to write papers efficiently when English isn't my first language?
Term for the "extreme-extension" version of a straw man fallacy?
When airplanes disconnect from a tanker during air to air refueling, why do they bank so sharply to the right?
What is meant by a M next to a roman numeral?
Is it my responsibility to learn a new technology in my own time my employer wants to implement?
Anatomically Correct Mesopelagic Aves
Is a stroke of luck acceptable after a series of unfavorable events?
How do spells that require an ability check vs. the caster's spell save DC work?
Pull the value of one cell into a userform based off another
The Next CEO of Stack OverflowHow to find a value in an excel column by vba code Cells.FindHow to avoid using Select in Excel VBAExcel find & replace cell contents based on contents of a list in another sheetPass UserForm textbox value to cellwith a VBA userform, how do you populate a combobox with a different text and value?Input values in Excel sheet through userformRestrict Userform responses to values in specific excel cellsVlookup on value given in textbox1 & textbox2 & return value in another testbox3 from sheet2excel vba columns to listboxPopulate TextBox with cell reference when cell is clicked while UserForm is openFill VBA UserForm TextBox with variable cells based on TextBox Name
I have a UserForm with a TextBox, which I am trying to populate the TextBox with the value of a cell 2 columns over from a cell I find that matches a specific value, EG: "ExampleValue1" in Cell "A2", and when a match is found, it will populate the TextBox with "ExampleValue2" in Cell "C2".
I have looked, and can't find anything that I can quite understand well enough to modify to suit my needs, and I have tried using the "Find" and "Index" Functions, but I can not get them to work properly. It may be that I am not setting them up properly, but I was wondering if anyone may have any suggestions or pointers to get me going in the right direction.
I checked out this thread (How to find a value in an excel column by vba code Cells.Find), but I can't seem to get it to do what I want in my case...
TextBox2 = Application.WorksheetFunction.Index(Sheets("References").Range("C1:C3"), Application.WorksheetFunction.Match(1, Sheets("References").Range("A1:A3"), 0), 1)
excel vba
asked Mar 21 at 16:26
gfritz25gfritz25
11
add a comment |
I have a UserForm with a TextBox, which I am trying to populate the TextBox with the value of a cell 2 columns over from a cell I find that matches a specific value, EG: "ExampleValue1" in Cell "A2", and when a match is found, it will populate the TextBox with "ExampleValue2" in Cell "C2".
I have looked, and can't find anything that I can quite understand well enough to modify to suit my needs, and I have tried using the "Find" and "Index" Functions, but I can not get them to work properly. It may be that I am not setting them up properly, but I was wondering if anyone may have any suggestions or pointers to get me going in the right direction.
I checked out this thread (How to find a value in an excel column by vba code Cells.Find), but I can't seem to get it to do what I want in my case...
TextBox2 = Application.WorksheetFunction.Index(Sheets("References").Range("C1:C3"), Application.WorksheetFunction.Match(1, Sheets("References").Range("A1:A3"), 0), 1)
excel vba
asked Mar 21 at 16:26
gfritz25gfritz25
11
2
You really need to post some of the code you've tried for us to give suggestions.
– Chrismas007
Mar 21 at 16:29
I don't have the exact code, as my work PC shut down last night for updates and I left the document open without having saved it with the code I tried, but I will see if I can find the example of the code I tried to modify. Give me a little bit and I'll see if I can reproduce it.
– gfritz25
Mar 21 at 17:08
add a comment |
I have a UserForm with a TextBox, which I am trying to populate the TextBox with the value of a cell 2 columns over from a cell I find that matches a specific value, EG: "ExampleValue1" in Cell "A2", and when a match is found, it will populate the TextBox with "ExampleValue2" in Cell "C2".
I have looked, and can't find anything that I can quite understand well enough to modify to suit my needs, and I have tried using the "Find" and "Index" Functions, but I can not get them to work properly. It may be that I am not setting them up properly, but I was wondering if anyone may have any suggestions or pointers to get me going in the right direction.
I checked out this thread (How to find a value in an excel column by vba code Cells.Find), but I can't seem to get it to do what I want in my case...
TextBox2 = Application.WorksheetFunction.Index(Sheets("References").Range("C1:C3"), Application.WorksheetFunction.Match(1, Sheets("References").Range("A1:A3"), 0), 1)
excel vba
asked Mar 21 at 16:26
gfritz25gfritz25
11
I have a UserForm with a TextBox, which I am trying to populate the TextBox with the value of a cell 2 columns over from a cell I find that matches a specific value, EG: "ExampleValue1" in Cell "A2", and when a match is found, it will populate the TextBox with "ExampleValue2" in Cell "C2".
I have looked, and can't find anything that I can quite understand well enough to modify to suit my needs, and I have tried using the "Find" and "Index" Functions, but I can not get them to work properly. It may be that I am not setting them up properly, but I was wondering if anyone may have any suggestions or pointers to get me going in the right direction.
I checked out this thread (How to find a value in an excel column by vba code Cells.Find), but I can't seem to get it to do what I want in my case...
TextBox2 = Application.WorksheetFunction.Index(Sheets("References").Range("C1:C3"), Application.WorksheetFunction.Match(1, Sheets("References").Range("A1:A3"), 0), 1)
excel vba
excel vba
asked Mar 21 at 16:26
gfritz25gfritz25
11
asked Mar 21 at 16:26
gfritz25gfritz25
11
edited Mar 21 at 17:31
gfritz25
asked Mar 21 at 16:26
gfritz25gfritz25
11
asked Mar 21 at 16:26
gfritz25gfritz25
11
asked Mar 21 at 16:26
gfritz25gfritz25
11
11
2
You really need to post some of the code you've tried for us to give suggestions.
– Chrismas007
Mar 21 at 16:29
I don't have the exact code, as my work PC shut down last night for updates and I left the document open without having saved it with the code I tried, but I will see if I can find the example of the code I tried to modify. Give me a little bit and I'll see if I can reproduce it.
– gfritz25
Mar 21 at 17:08
add a comment |
2
You really need to post some of the code you've tried for us to give suggestions.
– Chrismas007
Mar 21 at 16:29
I don't have the exact code, as my work PC shut down last night for updates and I left the document open without having saved it with the code I tried, but I will see if I can find the example of the code I tried to modify. Give me a little bit and I'll see if I can reproduce it.
– gfritz25
Mar 21 at 17:08
2
2
You really need to post some of the code you've tried for us to give suggestions.
– Chrismas007
Mar 21 at 16:29
You really need to post some of the code you've tried for us to give suggestions.
– Chrismas007
Mar 21 at 16:29
I don't have the exact code, as my work PC shut down last night for updates and I left the document open without having saved it with the code I tried, but I will see if I can find the example of the code I tried to modify. Give me a little bit and I'll see if I can reproduce it.
– gfritz25
Mar 21 at 17:08
I don't have the exact code, as my work PC shut down last night for updates and I left the document open without having saved it with the code I tried, but I will see if I can find the example of the code I tried to modify. Give me a little bit and I'll see if I can reproduce it.
– gfritz25
Mar 21 at 17:08
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
);
);
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%2f55285056%2fpull-the-value-of-one-cell-into-a-userform-based-off-another%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
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%2f55285056%2fpull-the-value-of-one-cell-into-a-userform-based-off-another%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
2
You really need to post some of the code you've tried for us to give suggestions.
– Chrismas007
Mar 21 at 16:29
I don't have the exact code, as my work PC shut down last night for updates and I left the document open without having saved it with the code I tried, but I will see if I can find the example of the code I tried to modify. Give me a little bit and I'll see if I can reproduce it.
– gfritz25
Mar 21 at 17:08