If you have an activeX/control toolbox toolbar checkbox named Checkbox1 on
your sheet, then put your sheet in design mode (with the control toolbox
toolbar) and double click on it. It should take you to

Private Sub CheckBox1_Click()

End Sub

You would replace that with my code (altered to really work with the right
ranges).

Mine is really just a model to give you ideas - I would need to know much
more information to actually write code that you would use.

If you want to send me a sample workbook with an explanation of what you
want to go where if it is not obvious, perhaps I can give you an example that
works.



--
Regards,
Tom Ogilvy


" wrote:

You were right in assuming that the rows of lighting are going to one
area of the estimate and rows of pipe
are going to another area of the estimate sheet. I like the idea of
defining a range in the Material sheet. I'm still a novice in VBA, so
I'm probibly going to sound ignorant here. Does the code you gave me
incorporate into my code or does it replace it? If it replaces it then
I'm getting an "Ambiguous" error in the first line "Private Sub
CheckBox1_Click() . How do I correct this? If I have to incorporate it
where would it go? What am I missing here?

I'm using checkboxes from the control toolbox toolbar.

Thanks for your help,
Keith