Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How find if target is object in Worksheet_Change (ByVal Target As.. ?)
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How find if target is object in Worksheet_Change (ByVal Target As.. ?)
Oh yes, thats right! - that explains why I used Worksheet_Calculate as
trigger today. Ít was a while since I wrote this code. I used the fact that checking calculate a "false/true" information in a hidden cell. I haven't worked with objects so much earlier, and need now even more help - can I continue to use ws_Calculate or am I on the wrong road? Grateful to any help Regards Gunnar "Bob Phillips" skrev i meddelandet ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How find if target is object in Worksheet_Change (ByVal Target As.. ?)
Gunnar,
I think you are on the wrong road. You can't use any worksheet event for controls, as they are not part of worksheet, but on a separate virtual layer. Control toolbox controls have their own events (click, etc.), whereas Forms controls are assigned macros. You need to work through these. -- 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 ... Oh yes, thats right! - that explains why I used Worksheet_Calculate as trigger today. Ít was a while since I wrote this code. I used the fact that checking calculate a "false/true" information in a hidden cell. I haven't worked with objects so much earlier, and need now even more help - can I continue to use ws_Calculate or am I on the wrong road? Grateful to any help Regards Gunnar "Bob Phillips" skrev i meddelandet ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
REPSOT?? Sub Worksheet_Change(ByVal Target As Range) | Excel Discussion (Misc queries) | |||
Control Toolbox and Private Sub Worksheet_Change(ByVal Target As R | Excel Discussion (Misc queries) | |||
Control Toolbox and Private Sub Worksheet_Change(ByVal Target | Excel Discussion (Misc queries) | |||
Excel VBA .... Worksheet_Change(ByVal Target As Range) question | Excel Programming | |||
Many Sub Worksheet_Change(ByVal Target As Range) In One Worksheet | Excel Programming |