I need help some with VBA coding
I'm having trouble with some VBA code, I'm just learning and don't know that much yet. I found a tutorial to make a registration form, copied the code, but when i try to enter this: 1stName.Additem (), it always puts a space between the 1 and st, so ends up like this: 1 stName.Additem(). Any help would be appreciated.
vba
edited Mar 4 at 13:15
Mathieu Guindon
44.5k770155
migrated from superuser.com Mar 4 at 10:27
This question came from our site for computer enthusiasts and power users.
add a comment |
I'm having trouble with some VBA code, I'm just learning and don't know that much yet. I found a tutorial to make a registration form, copied the code, but when i try to enter this: 1stName.Additem (), it always puts a space between the 1 and st, so ends up like this: 1 stName.Additem(). Any help would be appreciated.
vba
edited Mar 4 at 13:15
Mathieu Guindon
44.5k770155
migrated from superuser.com Mar 4 at 10:27
This question came from our site for computer enthusiasts and power users.
add a comment |
I'm having trouble with some VBA code, I'm just learning and don't know that much yet. I found a tutorial to make a registration form, copied the code, but when i try to enter this: 1stName.Additem (), it always puts a space between the 1 and st, so ends up like this: 1 stName.Additem(). Any help would be appreciated.
vba
edited Mar 4 at 13:15
Mathieu Guindon
44.5k770155
I'm having trouble with some VBA code, I'm just learning and don't know that much yet. I found a tutorial to make a registration form, copied the code, but when i try to enter this: 1stName.Additem (), it always puts a space between the 1 and st, so ends up like this: 1 stName.Additem(). Any help would be appreciated.
vba
vba
edited Mar 4 at 13:15
Mathieu Guindon
44.5k770155
edited Mar 4 at 13:15
Mathieu Guindon
44.5k770155
edited Mar 4 at 13:15
Mathieu Guindon
44.5k770155
edited Mar 4 at 13:15
Mathieu Guindon
44.5k770155
edited Mar 4 at 13:15
Mathieu Guindon
44.5k770155
44.5k770155
asked Feb 26 at 19:35
Redeye
migrated from superuser.com Mar 4 at 10:27
This question came from our site for computer enthusiasts and power users.
migrated from superuser.com Mar 4 at 10:27
This question came from our site for computer enthusiasts and power users.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Identifiers in VBA must begin with a letter: You can't have a legal variable/object name that begins with a digit. Rename your variable to FirstName instead of 1stName.
answered Feb 26 at 19:42
Mathieu GuindonMathieu Guindon
44.5k770155
2
There are also other restrictions. This may prove useful reading
– cybernetic.nomad
Feb 26 at 19:44
add a comment |
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%2f54981272%2fi-need-help-some-with-vba-coding%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Identifiers in VBA must begin with a letter: You can't have a legal variable/object name that begins with a digit. Rename your variable to FirstName instead of 1stName.
answered Feb 26 at 19:42
Mathieu GuindonMathieu Guindon
44.5k770155
2
There are also other restrictions. This may prove useful reading
– cybernetic.nomad
Feb 26 at 19:44
add a comment |
Identifiers in VBA must begin with a letter: You can't have a legal variable/object name that begins with a digit. Rename your variable to FirstName instead of 1stName.
answered Feb 26 at 19:42
Mathieu GuindonMathieu Guindon
44.5k770155
2
There are also other restrictions. This may prove useful reading
– cybernetic.nomad
Feb 26 at 19:44
add a comment |
Identifiers in VBA must begin with a letter: You can't have a legal variable/object name that begins with a digit. Rename your variable to FirstName instead of 1stName.
answered Feb 26 at 19:42
Mathieu GuindonMathieu Guindon
44.5k770155
Identifiers in VBA must begin with a letter: You can't have a legal variable/object name that begins with a digit. Rename your variable to FirstName instead of 1stName.
answered Feb 26 at 19:42
Mathieu GuindonMathieu Guindon
44.5k770155
answered Feb 26 at 19:42
Mathieu GuindonMathieu Guindon
44.5k770155
answered Feb 26 at 19:42
Mathieu GuindonMathieu Guindon
44.5k770155
answered Feb 26 at 19:42
Mathieu GuindonMathieu Guindon
44.5k770155
44.5k770155
2
There are also other restrictions. This may prove useful reading
– cybernetic.nomad
Feb 26 at 19:44
add a comment |
2
There are also other restrictions. This may prove useful reading
– cybernetic.nomad
Feb 26 at 19:44
2
2
There are also other restrictions. This may prove useful reading
– cybernetic.nomad
Feb 26 at 19:44
There are also other restrictions. This may prove useful reading
– cybernetic.nomad
Feb 26 at 19:44
add a comment |
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%2f54981272%2fi-need-help-some-with-vba-coding%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
