Solved: Events

[Opv]

When including more than one of either the Worksheet_Change, Worksheet_SelectionChange or Worksheet_BeforeDoubleClick event, are there any issues to consider as to whether they are all placed within a single Private Sub or in separate subs? Is there any advantage with one option over the other?

[Bob Phillips]

Of course, you place them in the code module of the worksheet that they apply to.

[Opv]

Of course, you place them in the code module of the worksheet that they apply to.

Thanks, but that is not my question. My question is whether it is better to place all the worksheet_beforeafterclick (or worksheet_change or worksheet_selectionchange) scripts in one sub or individual subs. Does it matter if they are all in one or individual subs?

P.S. I know each type goes in its own sub. I'm asking about groups of like scripts.

[GTO]

What do you mean by "in one sub"?

If you are asking whether this:
[vba]
Private Sub Worksheet_Change(ByVal Target As Range)
Call DoThis
Call DoThat
End Sub
[/vba]
or
[vba]
Private Sub Worksheet_Change(ByVal Target As Range)
Call DoThis
End Sub

Private Sub Worksheet_Change(ByVal Target As Range)
Call DoThat
End Sub
[/vba]
Then go with the first one as the latter will fail. You cannot have two same-named procedures in the same module.

[Opv]

What do you mean by "in one sub"?

Sorry for the confusion.... I mean:

[vba]
Private Sub Worksheet_BeforeDoubleClick(ByVal Target as Range)
'do first BeforeDoubleClick thing here

'do second BeforeDoubleClick thing here

'etc., etc.

[/vba]
OR

[vba]
Private Sub Worksheet_BeforeDoubleClick(ByVal Target as Range)
'do first BeforeDoubleClick thing here


[/vba]


[vba]
Private Sub Worksheet_BeforeDoubleClick(ByVal Target as Range)
'
'do second BeforeDoubleClick thing here

'etc., etc.

[/vba]

[Opv]

Then go with the first one as the latter will fail. You cannot have two same-named procedures in the same module.

Thanks. I appreciate the help.