Dynamic Form

[Johannes]

How can i create dynamic forms?
This is how my workbook is setup:
I have multiple sheets containing people info. Some area of info is marked
with red background color. Those are the once iam looking. So macro should
start from first sheet and look that region through and collect all red cell
info into a form and after that there should be chekcbox and if its chekcked
it changes that colour.
So that form can be any size and different number of checkboxes.
Thanks

 

[Tom Ogilvy]

What do you mean by Form?

Do you mean a userform?

http://j-walk.com/ss/excel/tips/userformtips.htm

 

[Tom Ogilvy]

The URL has tips on how to create a dynamic userform.