Mixing
![How to make a settings command [discord.js]](https://lh4.googleusercontent.com/-kWHF7GbknL4/AAAAAAAAAAI/AAAAAAAAGXw/pD7JDyHZnMA/s72-c/photo.jpg?sz=32)
How can I open a specific worksheet using VBA code on a command button macro?
I was wondering how can I open a specific worksheet using VBA code on a command button macro? When then user accesses my "Welcome Sheet" worksheet and clicks on the command button "Students" this should bring them to the "Students" worksheet.
I tried the following code but I got an invalid syntax error message as you can see in this image. Furthermore, some of the code turned to a red code and also one line had a yellow background effect as you can see in this image.
Code:
Private Sub CommandButton_2Click()
Sheets("Students").Activate
End Sub
Incase you wanted to check the command button macro is called the same name as written in the code my excel worksheet is linked below. However, I did check and to me it's all correct.
Video of me showing I have a worksheet called "Students" and I have correctly set up the command button correctly.
excel vba
asked Jan 2 at 20:27
Liam DochertyLiam Docherty
11
add a comment |
I was wondering how can I open a specific worksheet using VBA code on a command button macro? When then user accesses my "Welcome Sheet" worksheet and clicks on the command button "Students" this should bring them to the "Students" worksheet.
I tried the following code but I got an invalid syntax error message as you can see in this image. Furthermore, some of the code turned to a red code and also one line had a yellow background effect as you can see in this image.
Code:
Private Sub CommandButton_2Click()
Sheets("Students").Activate
End Sub
Incase you wanted to check the command button macro is called the same name as written in the code my excel worksheet is linked below. However, I did check and to me it's all correct.
Video of me showing I have a worksheet called "Students" and I have correctly set up the command button correctly.
excel vba
asked Jan 2 at 20:27
Liam DochertyLiam Docherty
11
TryActiveWorkbook.Worksheets("Students").Select
– Emily Alden
Jan 2 at 20:33
Syntax error @EmilyAlden
– Liam Docherty
Jan 2 at 20:44
add a comment |
I was wondering how can I open a specific worksheet using VBA code on a command button macro? When then user accesses my "Welcome Sheet" worksheet and clicks on the command button "Students" this should bring them to the "Students" worksheet.
I tried the following code but I got an invalid syntax error message as you can see in this image. Furthermore, some of the code turned to a red code and also one line had a yellow background effect as you can see in this image.
Code:
Private Sub CommandButton_2Click()
Sheets("Students").Activate
End Sub
Incase you wanted to check the command button macro is called the same name as written in the code my excel worksheet is linked below. However, I did check and to me it's all correct.
Video of me showing I have a worksheet called "Students" and I have correctly set up the command button correctly.
excel vba
asked Jan 2 at 20:27
Liam DochertyLiam Docherty
11
I was wondering how can I open a specific worksheet using VBA code on a command button macro? When then user accesses my "Welcome Sheet" worksheet and clicks on the command button "Students" this should bring them to the "Students" worksheet.
I tried the following code but I got an invalid syntax error message as you can see in this image. Furthermore, some of the code turned to a red code and also one line had a yellow background effect as you can see in this image.
Code:
Private Sub CommandButton_2Click()
Sheets("Students").Activate
End Sub
Incase you wanted to check the command button macro is called the same name as written in the code my excel worksheet is linked below. However, I did check and to me it's all correct.
Video of me showing I have a worksheet called "Students" and I have correctly set up the command button correctly.
excel vba
excel vba
asked Jan 2 at 20:27
Liam DochertyLiam Docherty
11
asked Jan 2 at 20:27
Liam DochertyLiam Docherty
11
asked Jan 2 at 20:27
Liam DochertyLiam Docherty
11
asked Jan 2 at 20:27
Liam DochertyLiam Docherty
11
asked Jan 2 at 20:27
Liam DochertyLiam Docherty
11
11
TryActiveWorkbook.Worksheets("Students").Select
– Emily Alden
Jan 2 at 20:33
Syntax error @EmilyAlden
– Liam Docherty
Jan 2 at 20:44
add a comment |
TryActiveWorkbook.Worksheets("Students").Select
– Emily Alden
Jan 2 at 20:33
Syntax error @EmilyAlden
– Liam Docherty
Jan 2 at 20:44
Try
ActiveWorkbook.Worksheets("Students").Select– Emily Alden
Jan 2 at 20:33
Try
ActiveWorkbook.Worksheets("Students").Select– Emily Alden
Jan 2 at 20:33
Syntax error @EmilyAlden
– Liam Docherty
Jan 2 at 20:44
Syntax error @EmilyAlden
– Liam Docherty
Jan 2 at 20:44
add a comment |
1 Answer
1
active
oldest
votes
Something like:
Private Sub CommandButton2_Click()
ThisWorkbook.WorkSheets("Students").Activate
End Sub
should do the trick. Remember to fully qualify your references (E.g. Workbook --> Sheet here), it'll save you headaches later!
answered Jan 2 at 20:38
Ryan WildryRyan Wildry
3,5611926
Thank you, I was using the wrong type of bracket symbol.
– Liam Docherty
Jan 2 at 20:53
@LiamDocherty I guess you have typed the name of the sub manually and it seems it should beCommandButton2_Click()
– Ibo
Jan 2 at 22:19
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%2f54012722%2fhow-can-i-open-a-specific-worksheet-using-vba-code-on-a-command-button-macro%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
Something like:
Private Sub CommandButton2_Click()
ThisWorkbook.WorkSheets("Students").Activate
End Sub
should do the trick. Remember to fully qualify your references (E.g. Workbook --> Sheet here), it'll save you headaches later!
answered Jan 2 at 20:38
Ryan WildryRyan Wildry
3,5611926
Thank you, I was using the wrong type of bracket symbol.
– Liam Docherty
Jan 2 at 20:53
@LiamDocherty I guess you have typed the name of the sub manually and it seems it should beCommandButton2_Click()
– Ibo
Jan 2 at 22:19
add a comment |
Something like:
Private Sub CommandButton2_Click()
ThisWorkbook.WorkSheets("Students").Activate
End Sub
should do the trick. Remember to fully qualify your references (E.g. Workbook --> Sheet here), it'll save you headaches later!
answered Jan 2 at 20:38
Ryan WildryRyan Wildry
3,5611926
Thank you, I was using the wrong type of bracket symbol.
– Liam Docherty
Jan 2 at 20:53
@LiamDocherty I guess you have typed the name of the sub manually and it seems it should beCommandButton2_Click()
– Ibo
Jan 2 at 22:19
add a comment |
Something like:
Private Sub CommandButton2_Click()
ThisWorkbook.WorkSheets("Students").Activate
End Sub
should do the trick. Remember to fully qualify your references (E.g. Workbook --> Sheet here), it'll save you headaches later!
answered Jan 2 at 20:38
Ryan WildryRyan Wildry
3,5611926
Something like:
Private Sub CommandButton2_Click()
ThisWorkbook.WorkSheets("Students").Activate
End Sub
should do the trick. Remember to fully qualify your references (E.g. Workbook --> Sheet here), it'll save you headaches later!
answered Jan 2 at 20:38
Ryan WildryRyan Wildry
3,5611926
edited Jan 3 at 0:42
answered Jan 2 at 20:38
Ryan WildryRyan Wildry
3,5611926
answered Jan 2 at 20:38
Ryan WildryRyan Wildry
3,5611926
answered Jan 2 at 20:38
Ryan WildryRyan Wildry
3,5611926
3,5611926
Thank you, I was using the wrong type of bracket symbol.
– Liam Docherty
Jan 2 at 20:53
@LiamDocherty I guess you have typed the name of the sub manually and it seems it should beCommandButton2_Click()
– Ibo
Jan 2 at 22:19
add a comment |
Thank you, I was using the wrong type of bracket symbol.
– Liam Docherty
Jan 2 at 20:53
@LiamDocherty I guess you have typed the name of the sub manually and it seems it should beCommandButton2_Click()
– Ibo
Jan 2 at 22:19
Thank you, I was using the wrong type of bracket symbol.
– Liam Docherty
Jan 2 at 20:53
Thank you, I was using the wrong type of bracket symbol.
– Liam Docherty
Jan 2 at 20:53
@LiamDocherty I guess you have typed the name of the sub manually and it seems it should be
CommandButton2_Click()– Ibo
Jan 2 at 22:19
@LiamDocherty I guess you have typed the name of the sub manually and it seems it should be
CommandButton2_Click()– Ibo
Jan 2 at 22:19
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%2f54012722%2fhow-can-i-open-a-specific-worksheet-using-vba-code-on-a-command-button-macro%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
Try
ActiveWorkbook.Worksheets("Students").Select– Emily Alden
Jan 2 at 20:33
Syntax error @EmilyAlden
– Liam Docherty
Jan 2 at 20:44