View Full Version : Help:Just some clarification...

07-16-2007, 10:59 AM
I have read some where something like:

Worksheet_SelectionChange(ByVal Target As Range)
Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
Worksheet_Change(ByVal Target As Range)
Please, anyone help me in telling what is the default name (the name rule) for sub in worksheet so excel can understand it's an event code?

When reading help in VBA, they just show me the last bullet code --> Worksheet_Change(ByVal Target As Range)

07-16-2007, 11:06 AM
BTW, Any relative subject, event subject... is also appreciated. I'm very new to VBA. Pls help in sharing ;)

07-16-2007, 12:01 PM
See http://www.cpearson.com/excel/events.htm

07-16-2007, 01:58 PM
The easiest way to make sure you get the correct syntax is to use the dropdowns in the VBE.

07-16-2007, 09:01 PM
many thanks, you all are so kind ;)