LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 470
Default Code Question

What do the following statements mean or do?

1) Private Sub Worksheet_Change(ByVal Target As Range)
Worksheets("Order").Activate
If Target.Count 1 Then Exit Sub
If IsEmpty(Target.Value) Then Exit Sub

I know the above will execute when there is a change on the worksheet, but I
don't know what the part in the () does or means. I have also been unable
to locate in the HELP section anything to do with TARGET.xxxxxxx.

2) Application.EnableEvent = TRUE/FALSE

What does this command affect and why would it be used?

3) If Not Intersect(Target, Range("A13:B90")) Is Nothing Then
If Target.Column = 1 Then

All above programming appear in a macro I use, but I was given the code via
this forum from questions I had.


Thanks,
Les
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
VB Code Question Stan Excel Discussion (Misc queries) 6 April 30th 07 11:27 PM
VBA code question JEV Excel Discussion (Misc queries) 2 March 1st 07 06:02 PM
Code Question Michael168[_111_] Excel Programming 9 September 17th 04 06:31 AM
Code Question Mikk Excel Programming 1 January 23rd 04 12:21 AM
VBA Code Question Theresa[_4_] Excel Programming 6 October 16th 03 07:06 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"