Posted to microsoft.public.excel.programming

AA2e72E[_2_] AA2e72E[_2_] is offline

external usenet poster

Posts: 93

Automation Events

In Visual Basic, how do I code this statement, xl.SheetSelectionChange = "Newx" to trap the selection change event

Private Sub Form_Load(
Set xl = CreateObject("Excel.Application"
xl.Workbooks.Ad
xl.SheetSelection.Change = "Newx
xl.Cells(1, 4).Selec
End Su

Sub Newx(
' ... cod
End Su

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
events?	[email protected]	Excel Discussion (Misc queries)	1	September 14th 05 03:26 PM
Is there a way to turn events on or off?	Angus Comber[_2_]	Excel Programming	1	November 6th 03 01:11 PM
events	Mark[_17_]	Excel Programming	1	October 31st 03 09:18 AM
events	Mark[_17_]	Excel Programming	1	October 29th 03 12:56 PM
Workbook Events	Geoff[_8_]	Excel Programming	0	September 13th 03 09:28 AM

All times are GMT +1. The time now is 02:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us