Leith Ross Wrote:
Hello Dreamz,
Your right about the changes I made to your code. Keep the code as is
and qualify the CheckBoxes. You didn't mention the name of UserForm the
checkboxes are on, so I didn't include it in the code changes. Am I
wrong in asssuming the checkboxes are on UserForm or do you have them
on aWorksheet(s)?
Thanks,
Leith
you are correct in your assumption. the checkboxes are on the userform
(named Dialog in my workbook).
here's what i did.
for the code:
Code:
--------------------
If chDep Then
--------------------
i tried changing it to:
Code:
--------------------
If Dialog.chDep Then
--------------------
that didn't work, so i tried:
Code:
--------------------
If Dialog.chDep.Value Then
--------------------
.. again, no change, so next:
Code:
--------------------
If Dialog.chDep.Value = True Then
--------------------
but to no avail. the macro did not paste my list anywhere (but those
cells were copied; i.e. the selection rectangle was moving).
--
dreamz
------------------------------------------------------------------------
dreamz's Profile:
http://www.excelforum.com/member.php...o&userid=26462
View this thread:
http://www.excelforum.com/showthread...hreadid=480621