Mixing
How do I enter data into a userform from another workbook using VBA?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
So, the problem I'm having is that some code I am writing calls another macro. This second macro has a userform with fields that must be completed before it will continue.
Is there any way I can have code in the first macro that will enter data into the userform from the second?
The main problem here is that I don't have access to the code in the second macro. As far as I understand, this means:
(1) I can't bypass the form and pass the variables directly to the second macro's code as I can't edit the second macro.
(2) I can't call an event when the userform activates as that code would need to be in the second macro and I can only edit the first, which pauses once the second macro is called.
(3) I can't use an application event as there isn't one that covers a userform popping up.
Any ideas?
Thanks in advance!
Phil.
forms userform
asked Jan 3 at 13:01
Phil TPhil T
33
add a comment |
So, the problem I'm having is that some code I am writing calls another macro. This second macro has a userform with fields that must be completed before it will continue.
Is there any way I can have code in the first macro that will enter data into the userform from the second?
The main problem here is that I don't have access to the code in the second macro. As far as I understand, this means:
(1) I can't bypass the form and pass the variables directly to the second macro's code as I can't edit the second macro.
(2) I can't call an event when the userform activates as that code would need to be in the second macro and I can only edit the first, which pauses once the second macro is called.
(3) I can't use an application event as there isn't one that covers a userform popping up.
Any ideas?
Thanks in advance!
Phil.
forms userform
asked Jan 3 at 13:01
Phil TPhil T
33
add a comment |
So, the problem I'm having is that some code I am writing calls another macro. This second macro has a userform with fields that must be completed before it will continue.
Is there any way I can have code in the first macro that will enter data into the userform from the second?
The main problem here is that I don't have access to the code in the second macro. As far as I understand, this means:
(1) I can't bypass the form and pass the variables directly to the second macro's code as I can't edit the second macro.
(2) I can't call an event when the userform activates as that code would need to be in the second macro and I can only edit the first, which pauses once the second macro is called.
(3) I can't use an application event as there isn't one that covers a userform popping up.
Any ideas?
Thanks in advance!
Phil.
forms userform
asked Jan 3 at 13:01
Phil TPhil T
33
So, the problem I'm having is that some code I am writing calls another macro. This second macro has a userform with fields that must be completed before it will continue.
Is there any way I can have code in the first macro that will enter data into the userform from the second?
The main problem here is that I don't have access to the code in the second macro. As far as I understand, this means:
(1) I can't bypass the form and pass the variables directly to the second macro's code as I can't edit the second macro.
(2) I can't call an event when the userform activates as that code would need to be in the second macro and I can only edit the first, which pauses once the second macro is called.
(3) I can't use an application event as there isn't one that covers a userform popping up.
Any ideas?
Thanks in advance!
Phil.
forms userform
forms userform
asked Jan 3 at 13:01
Phil TPhil T
33
asked Jan 3 at 13:01
Phil TPhil T
33
edited Jan 4 at 7:43
Phil T
asked Jan 3 at 13:01
Phil TPhil T
33
asked Jan 3 at 13:01
Phil TPhil T
33
asked Jan 3 at 13:01
Phil TPhil T
33
33
add a comment |
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%2f54022835%2fhow-do-i-enter-data-into-a-userform-from-another-workbook-using-vba%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%2f54022835%2fhow-do-i-enter-data-into-a-userform-from-another-workbook-using-vba%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
