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

What do you mean by Form?

Do you mean a userform?

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


--
Regards,
Tom Ogilvy


"Johannes" wrote in message ...
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

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

--
Regards,
Tom Ogilvy

"Johannes" wrote in message
...
Yes i mean userform. If you understood what looking for maybe you can
suggest me something else? I just though separete form could be easy to
use.


"Tom Ogilvy" wrote in message
...
What do you mean by Form?

Do you mean a userform?

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


--
Regards,
Tom Ogilvy


"Johannes" wrote in message
...
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