Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Checkbox Creation on a UserForm
On my spreadsheet I have 3 sheets. Sheet2 is called "Team
Management Database". On Row 4 starting in column A, I have names. I have a UserForm(UserForm1). I would like for the code to look on Sheet2 and for each name it finds in Row4, I would like it to create a checkbox with that name, and place the checkbox on UserForm1. If the only names are Todd, Dan, and Mary, I would like for 3 check boxes to be created on Userform1. Checkbox1 would be named Todd, Checkbox2 would be named Dan, and Checkbox3 would be named Mary. It does not matter the position on the userform the checkboxes are created, but preferably directly below the first checkbox. Thank you Todd Huttenstine |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Checkbox Creation on a UserForm
Why not use a listbox and set the liststyle property to fmListStyleOption
and the multiselect property to True. This will list your names with checkboxes in front of them. A lot easier than trying to manage a bunch of Checkboxes. -- Regards, Tom Ogilvy "Todd Huttenstine" wrote in message ... On my spreadsheet I have 3 sheets. Sheet2 is called "Team Management Database". On Row 4 starting in column A, I have names. I have a UserForm(UserForm1). I would like for the code to look on Sheet2 and for each name it finds in Row4, I would like it to create a checkbox with that name, and place the checkbox on UserForm1. If the only names are Todd, Dan, and Mary, I would like for 3 check boxes to be created on Userform1. Checkbox1 would be named Todd, Checkbox2 would be named Dan, and Checkbox3 would be named Mary. It does not matter the position on the userform the checkboxes are created, but preferably directly below the first checkbox. Thank you Todd Huttenstine |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting and userform | Excel Discussion (Misc queries) | |||
Checkbox and conditional formating | Excel Discussion (Misc queries) | |||
Font Issues when using UserForm box after clicking a Checkbox | Excel Discussion (Misc queries) | |||
using a checkbox for a conditional function | Excel Worksheet Functions | |||
Conditional Formating with Checkbox | Excel Worksheet Functions |