PDA

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



yurble_vn
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)

yurble_vn
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 ;)

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

Norie
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.

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