Worksheet_SelectionChange(ByVal Target As Range) questions
 

excel pros:

1. is it acceptable to place more than 1 control per sheet? if so, is there
some limit?

2. is there any way to have one control applied to every sheet, or a range
of sheets? or, does the code have to be placed on each sheet?

thanks

--


Gary

Worksheet_SelectionChange(ByVal Target As Range) questions
 

Hi Gary,

1. is it acceptable to place more than 1 control per sheet? if so, is
there some limit?

I am not sure what you mean by 'control' in this context, but looking at
your subject for clues, the event code can respond to multiple triggers.
Please provide some additional explanation.

2. is there any way to have one control applied to every sheet, or a range
of sheets? or, does the code have to be placed on each sheet?

Look at Workbook event procedures and, specifically at the
Workbookbook_SheetSelectionChange event. Thie event corresponds to the
Worksheet_SelectionChange event but operates at workbook level, i.e. the
event occurs with selection change on any worksheet.


---
Regards,
Norman



"Gary Keramidas" wrote in message
...
excel pros:

1. is it acceptable to place more than 1 control per sheet? if so, is
there some limit?

2. is there any way to have one control applied to every sheet, or a range
of sheets? or, does the code have to be placed on each sheet?

thanks

--


Gary

Worksheet_SelectionChange(ByVal Target As Range) questions
 

ok, thanks.

you guessed what i meant. multiple events triggers on each worksheet code
page.

--


Gary


"Norman Jones" wrote in message
...
Hi Gary,

1. is it acceptable to place more than 1 control per sheet? if so, is
there some limit?

I am not sure what you mean by 'control' in this context, but looking at
your subject for clues, the event code can respond to multiple triggers.
Please provide some additional explanation.

2. is there any way to have one control applied to every sheet, or a
range of sheets? or, does the code have to be placed on each sheet?

Look at Workbook event procedures and, specifically at the
Workbookbook_SheetSelectionChange event. Thie event corresponds to the
Worksheet_SelectionChange event but operates at workbook level, i.e. the
event occurs with selection change on any worksheet.


---
Regards,
Norman



"Gary Keramidas" wrote in message
...
excel pros:

1. is it acceptable to place more than 1 control per sheet? if so, is
there some limit?

2. is there any way to have one control applied to every sheet, or a
range of sheets? or, does the code have to be placed on each sheet?

thanks

--


Gary