Mixing
Method or data member not found - TextBox
I have 2 textBoxs located in userform1, then I have 2 buttons that opens userform2 and userform4 respectively, when those userforms open, the user has the option to add some new info to the textboxs in userform1.
The problem is, when I click button 1 and try to add new info, it gives me the following error: method or data member not found.
I tried with userform1.textbox6.text and without: textbox6.text
But none worked
Here is a piece of code where I get the error:
lr = Worksheets("CGI").Cells(Rows.Count, 2).End(xlUp).Row
Worksheets("CGI").Cells(lr + 1, 2).Value = UserForm1.TextBox6.Text
UserForm1.TextBox6.Text = ""
I appreciate in advance any help you guys can give!
excel textbox userform
edited Jan 4 at 5:47
Daniel L. VanDenBosch
546524
asked Jan 2 at 21:47
VivianVivian
1
add a comment |
I have 2 textBoxs located in userform1, then I have 2 buttons that opens userform2 and userform4 respectively, when those userforms open, the user has the option to add some new info to the textboxs in userform1.
The problem is, when I click button 1 and try to add new info, it gives me the following error: method or data member not found.
I tried with userform1.textbox6.text and without: textbox6.text
But none worked
Here is a piece of code where I get the error:
lr = Worksheets("CGI").Cells(Rows.Count, 2).End(xlUp).Row
Worksheets("CGI").Cells(lr + 1, 2).Value = UserForm1.TextBox6.Text
UserForm1.TextBox6.Text = ""
I appreciate in advance any help you guys can give!
excel textbox userform
edited Jan 4 at 5:47
Daniel L. VanDenBosch
546524
asked Jan 2 at 21:47
VivianVivian
1
I can only guess, but are you usingVBAand excel? If so, I would add them to the tags or specify them in your question.
– Daniel L. VanDenBosch
Jan 2 at 21:54
Hi Daniel, sorry.. forgot to mention, I'm using an excel sheet to draw the values that I have in the userform
– Vivian
Jan 3 at 18:23
add a comment |
I have 2 textBoxs located in userform1, then I have 2 buttons that opens userform2 and userform4 respectively, when those userforms open, the user has the option to add some new info to the textboxs in userform1.
The problem is, when I click button 1 and try to add new info, it gives me the following error: method or data member not found.
I tried with userform1.textbox6.text and without: textbox6.text
But none worked
Here is a piece of code where I get the error:
lr = Worksheets("CGI").Cells(Rows.Count, 2).End(xlUp).Row
Worksheets("CGI").Cells(lr + 1, 2).Value = UserForm1.TextBox6.Text
UserForm1.TextBox6.Text = ""
I appreciate in advance any help you guys can give!
excel textbox userform
edited Jan 4 at 5:47
Daniel L. VanDenBosch
546524
asked Jan 2 at 21:47
VivianVivian
1
I have 2 textBoxs located in userform1, then I have 2 buttons that opens userform2 and userform4 respectively, when those userforms open, the user has the option to add some new info to the textboxs in userform1.
The problem is, when I click button 1 and try to add new info, it gives me the following error: method or data member not found.
I tried with userform1.textbox6.text and without: textbox6.text
But none worked
Here is a piece of code where I get the error:
lr = Worksheets("CGI").Cells(Rows.Count, 2).End(xlUp).Row
Worksheets("CGI").Cells(lr + 1, 2).Value = UserForm1.TextBox6.Text
UserForm1.TextBox6.Text = ""
I appreciate in advance any help you guys can give!
excel textbox userform
excel textbox userform
edited Jan 4 at 5:47
Daniel L. VanDenBosch
546524
asked Jan 2 at 21:47
VivianVivian
1
edited Jan 4 at 5:47
Daniel L. VanDenBosch
546524
asked Jan 2 at 21:47
VivianVivian
1
edited Jan 4 at 5:47
Daniel L. VanDenBosch
546524
edited Jan 4 at 5:47
Daniel L. VanDenBosch
546524
edited Jan 4 at 5:47
Daniel L. VanDenBosch
546524
546524
asked Jan 2 at 21:47
VivianVivian
1
asked Jan 2 at 21:47
VivianVivian
1
asked Jan 2 at 21:47
VivianVivian
1
1
I can only guess, but are you usingVBAand excel? If so, I would add them to the tags or specify them in your question.
– Daniel L. VanDenBosch
Jan 2 at 21:54
Hi Daniel, sorry.. forgot to mention, I'm using an excel sheet to draw the values that I have in the userform
– Vivian
Jan 3 at 18:23
add a comment |
I can only guess, but are you usingVBAand excel? If so, I would add them to the tags or specify them in your question.
– Daniel L. VanDenBosch
Jan 2 at 21:54
Hi Daniel, sorry.. forgot to mention, I'm using an excel sheet to draw the values that I have in the userform
– Vivian
Jan 3 at 18:23
I can only guess, but are you using
VBA and excel? If so, I would add them to the tags or specify them in your question.– Daniel L. VanDenBosch
Jan 2 at 21:54
I can only guess, but are you using
VBA and excel? If so, I would add them to the tags or specify them in your question.– Daniel L. VanDenBosch
Jan 2 at 21:54
Hi Daniel, sorry.. forgot to mention, I'm using an excel sheet to draw the values that I have in the userform
– Vivian
Jan 3 at 18:23
Hi Daniel, sorry.. forgot to mention, I'm using an excel sheet to draw the values that I have in the userform
– Vivian
Jan 3 at 18:23
add a comment |
0
active
oldest
votes
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%2f54013593%2fmethod-or-data-member-not-found-textbox%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%2f54013593%2fmethod-or-data-member-not-found-textbox%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
I can only guess, but are you using
VBAand excel? If so, I would add them to the tags or specify them in your question.– Daniel L. VanDenBosch
Jan 2 at 21:54
Hi Daniel, sorry.. forgot to mention, I'm using an excel sheet to draw the values that I have in the userform
– Vivian
Jan 3 at 18:23