How to add a checklistbox to an Excel workbook
up vote
0
down vote
favorite
I'm working as a support engineer on a complex solution, based on several distinct applications, and regularly I get questions on a certain feature, covered by (multiple) applications, mentioning certain events (memory leaks, going into crashes, ...).
I'm currently building an Excel sheet, where I have one column, called "Processes/Features", which should contain a checklistbox, mentioning the applications and the features and the events, so that I can check several ones of them.
Unfortunately:
- When I choose "Developer" menu, "Insert", "Combo List - Edit", this seems to be disabled, and I'm not even sure if this is what I'm looking for.
- When I choose "Developer" menu, "Add-ins", I don't find what I'm looking for.
Does anybody know how to add a CheckListBox to my Excel sheet?
Edit
It seems to be possible to download ActiveX controls and add them to my Excel sheet. If I do that, what will other users see who open the Excel sheet when they don't have added the ActiveX on their PC?
microsoft-excel microsoft-excel-2016 components
asked Nov 27 at 9:14
Dominique
57611028
|
show 2 more comments
up vote
0
down vote
favorite
I'm working as a support engineer on a complex solution, based on several distinct applications, and regularly I get questions on a certain feature, covered by (multiple) applications, mentioning certain events (memory leaks, going into crashes, ...).
I'm currently building an Excel sheet, where I have one column, called "Processes/Features", which should contain a checklistbox, mentioning the applications and the features and the events, so that I can check several ones of them.
Unfortunately:
- When I choose "Developer" menu, "Insert", "Combo List - Edit", this seems to be disabled, and I'm not even sure if this is what I'm looking for.
- When I choose "Developer" menu, "Add-ins", I don't find what I'm looking for.
Does anybody know how to add a CheckListBox to my Excel sheet?
Edit
It seems to be possible to download ActiveX controls and add them to my Excel sheet. If I do that, what will other users see who open the Excel sheet when they don't have added the ActiveX on their PC?
microsoft-excel microsoft-excel-2016 components
asked Nov 27 at 9:14
Dominique
57611028
Add Check Box to the Sheet is not big task,, but the crucial one is what you are trying to achieve!! Better make the issue more clear and add some screen shot also to show the expected result.
– Rajesh S
Nov 27 at 9:44
Meanwhile to this ,,, ClickDeveloper Tabthen hitDesignand finally left to it you findInsert. From the pop up list findActive X Controlselect 3rd oneActive X Checkbox Control☺
– Rajesh S
Nov 27 at 9:49
@RajeshS: The checkbox control only contains one item, I'm looking for a checklistbox, which contains multiple items which can be checked.
– Dominique
Nov 27 at 11:15
1
,,, for multiple Checkbox first select & draw GROUP CONTROL you find in Form Control category on same pop up menu then draw as many Checkbox controls inside Group Control. ☺
– Rajesh S
Nov 28 at 6:37
@RajeshS: thanks for your reply, but it's quite disappointing: when I was programming in Delphi, the VCL (Visual Component Library) contained a TCheckListBox (a listbox of checkable items), and as I have stopped working with Delphi in 2002, I figured that such a component would be available anywhere (and in case not anywhere there would now be an add-in for that), hence my question.
– Dominique
Nov 28 at 7:44
|
show 2 more comments
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I'm working as a support engineer on a complex solution, based on several distinct applications, and regularly I get questions on a certain feature, covered by (multiple) applications, mentioning certain events (memory leaks, going into crashes, ...).
I'm currently building an Excel sheet, where I have one column, called "Processes/Features", which should contain a checklistbox, mentioning the applications and the features and the events, so that I can check several ones of them.
Unfortunately:
- When I choose "Developer" menu, "Insert", "Combo List - Edit", this seems to be disabled, and I'm not even sure if this is what I'm looking for.
- When I choose "Developer" menu, "Add-ins", I don't find what I'm looking for.
Does anybody know how to add a CheckListBox to my Excel sheet?
Edit
It seems to be possible to download ActiveX controls and add them to my Excel sheet. If I do that, what will other users see who open the Excel sheet when they don't have added the ActiveX on their PC?
microsoft-excel microsoft-excel-2016 components
asked Nov 27 at 9:14
Dominique
57611028
I'm working as a support engineer on a complex solution, based on several distinct applications, and regularly I get questions on a certain feature, covered by (multiple) applications, mentioning certain events (memory leaks, going into crashes, ...).
I'm currently building an Excel sheet, where I have one column, called "Processes/Features", which should contain a checklistbox, mentioning the applications and the features and the events, so that I can check several ones of them.
Unfortunately:
- When I choose "Developer" menu, "Insert", "Combo List - Edit", this seems to be disabled, and I'm not even sure if this is what I'm looking for.
- When I choose "Developer" menu, "Add-ins", I don't find what I'm looking for.
Does anybody know how to add a CheckListBox to my Excel sheet?
Edit
It seems to be possible to download ActiveX controls and add them to my Excel sheet. If I do that, what will other users see who open the Excel sheet when they don't have added the ActiveX on their PC?
microsoft-excel microsoft-excel-2016 components
microsoft-excel microsoft-excel-2016 components
asked Nov 27 at 9:14
Dominique
57611028
asked Nov 27 at 9:14
Dominique
57611028
edited Nov 28 at 13:29
asked Nov 27 at 9:14
Dominique
57611028
asked Nov 27 at 9:14
Dominique
57611028
asked Nov 27 at 9:14
Dominique
57611028
57611028
Add Check Box to the Sheet is not big task,, but the crucial one is what you are trying to achieve!! Better make the issue more clear and add some screen shot also to show the expected result.
– Rajesh S
Nov 27 at 9:44
Meanwhile to this ,,, ClickDeveloper Tabthen hitDesignand finally left to it you findInsert. From the pop up list findActive X Controlselect 3rd oneActive X Checkbox Control☺
– Rajesh S
Nov 27 at 9:49
@RajeshS: The checkbox control only contains one item, I'm looking for a checklistbox, which contains multiple items which can be checked.
– Dominique
Nov 27 at 11:15
1
,,, for multiple Checkbox first select & draw GROUP CONTROL you find in Form Control category on same pop up menu then draw as many Checkbox controls inside Group Control. ☺
– Rajesh S
Nov 28 at 6:37
@RajeshS: thanks for your reply, but it's quite disappointing: when I was programming in Delphi, the VCL (Visual Component Library) contained a TCheckListBox (a listbox of checkable items), and as I have stopped working with Delphi in 2002, I figured that such a component would be available anywhere (and in case not anywhere there would now be an add-in for that), hence my question.
– Dominique
Nov 28 at 7:44
|
show 2 more comments
Add Check Box to the Sheet is not big task,, but the crucial one is what you are trying to achieve!! Better make the issue more clear and add some screen shot also to show the expected result.
– Rajesh S
Nov 27 at 9:44
Meanwhile to this ,,, ClickDeveloper Tabthen hitDesignand finally left to it you findInsert. From the pop up list findActive X Controlselect 3rd oneActive X Checkbox Control☺
– Rajesh S
Nov 27 at 9:49
@RajeshS: The checkbox control only contains one item, I'm looking for a checklistbox, which contains multiple items which can be checked.
– Dominique
Nov 27 at 11:15
1
,,, for multiple Checkbox first select & draw GROUP CONTROL you find in Form Control category on same pop up menu then draw as many Checkbox controls inside Group Control. ☺
– Rajesh S
Nov 28 at 6:37
@RajeshS: thanks for your reply, but it's quite disappointing: when I was programming in Delphi, the VCL (Visual Component Library) contained a TCheckListBox (a listbox of checkable items), and as I have stopped working with Delphi in 2002, I figured that such a component would be available anywhere (and in case not anywhere there would now be an add-in for that), hence my question.
– Dominique
Nov 28 at 7:44
Add Check Box to the Sheet is not big task,, but the crucial one is what you are trying to achieve!! Better make the issue more clear and add some screen shot also to show the expected result.
– Rajesh S
Nov 27 at 9:44
Add Check Box to the Sheet is not big task,, but the crucial one is what you are trying to achieve!! Better make the issue more clear and add some screen shot also to show the expected result.
– Rajesh S
Nov 27 at 9:44
Meanwhile to this ,,, Click
Developer Tab then hit Design and finally left to it you find Insert. From the pop up list find Active X Control select 3rd one Active X Checkbox Control ☺– Rajesh S
Nov 27 at 9:49
Meanwhile to this ,,, Click
Developer Tab then hit Design and finally left to it you find Insert. From the pop up list find Active X Control select 3rd one Active X Checkbox Control ☺– Rajesh S
Nov 27 at 9:49
@RajeshS: The checkbox control only contains one item, I'm looking for a checklistbox, which contains multiple items which can be checked.
– Dominique
Nov 27 at 11:15
@RajeshS: The checkbox control only contains one item, I'm looking for a checklistbox, which contains multiple items which can be checked.
– Dominique
Nov 27 at 11:15
1
1
,,, for multiple Checkbox first select & draw GROUP CONTROL you find in Form Control category on same pop up menu then draw as many Checkbox controls inside Group Control. ☺
– Rajesh S
Nov 28 at 6:37
,,, for multiple Checkbox first select & draw GROUP CONTROL you find in Form Control category on same pop up menu then draw as many Checkbox controls inside Group Control. ☺
– Rajesh S
Nov 28 at 6:37
@RajeshS: thanks for your reply, but it's quite disappointing: when I was programming in Delphi, the VCL (Visual Component Library) contained a TCheckListBox (a listbox of checkable items), and as I have stopped working with Delphi in 2002, I figured that such a component would be available anywhere (and in case not anywhere there would now be an add-in for that), hence my question.
– Dominique
Nov 28 at 7:44
@RajeshS: thanks for your reply, but it's quite disappointing: when I was programming in Delphi, the VCL (Visual Component Library) contained a TCheckListBox (a listbox of checkable items), and as I have stopped working with Delphi in 2002, I figured that such a component would be available anywhere (and in case not anywhere there would now be an add-in for that), hence my question.
– Dominique
Nov 28 at 7:44
|
show 2 more comments
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Super User!
- 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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2fsuperuser.com%2fquestions%2f1378697%2fhow-to-add-a-checklistbox-to-an-excel-workbook%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
Add Check Box to the Sheet is not big task,, but the crucial one is what you are trying to achieve!! Better make the issue more clear and add some screen shot also to show the expected result.
– Rajesh S
Nov 27 at 9:44
Meanwhile to this ,,, Click
Developer Tabthen hitDesignand finally left to it you findInsert. From the pop up list findActive X Controlselect 3rd oneActive X Checkbox Control☺– Rajesh S
Nov 27 at 9:49
@RajeshS: The checkbox control only contains one item, I'm looking for a checklistbox, which contains multiple items which can be checked.
– Dominique
Nov 27 at 11:15
1
,,, for multiple Checkbox first select & draw GROUP CONTROL you find in Form Control category on same pop up menu then draw as many Checkbox controls inside Group Control. ☺
– Rajesh S
Nov 28 at 6:37
@RajeshS: thanks for your reply, but it's quite disappointing: when I was programming in Delphi, the VCL (Visual Component Library) contained a TCheckListBox (a listbox of checkable items), and as I have stopped working with Delphi in 2002, I figured that such a component would be available anywhere (and in case not anywhere there would now be an add-in for that), hence my question.
– Dominique
Nov 28 at 7:44