How find if target is object in Worksheet_Change (ByVal Target As.. ?)
A checkbox doesn't trigger the Worksheet_Change event.
You need to identify this in the checkbox event or macro.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Gunnar Johansson" wrote in message
...
Hi,
A / I need to act different if the target of change is a checkbox or if it
is a range (or cell).
B / I also need to be able to separate what specific checkbox is changing.
I
need to run different subroutines depending on which checkbox is changing.
Kan anyone give me a hint how to do this?
Regards
Gunnar
|