View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Todd Huttenstine[_2_] Todd Huttenstine[_2_] is offline
external usenet poster
 
Posts: 237
Default 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