View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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