Using
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Then Exit Sub

What kind of things (list most obvious) can happen to make this statement
TRUE?
TIA,

This will happen when more than one cell is selected and the user edits the
highlighted cell. Can't think of any other circumstances.

TH

On 5/2/04 17:08, in article Jcflc.3306$nN6.50@lakeread06, "JMay"
wrote:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Then Exit Sub

Thanks TH, but
I enter data in all cells A1:B4.
With A1 the activecell I highlight A1:B4
If I press F2 (on the automatically highlite Activecell - A1) and change the
data in it only
and press the enter key my MsgBox **does not** appear.
Using:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Then
MsgBox ("Statement is True")
End If
End Sub

What am I missing?


"TH" wrote in message
...
This will happen when more than one cell is selected and the user edits
the
highlighted cell. Can't think of any other circumstances.

TH

On 5/2/04 17:08, in article Jcflc.3306$nN6.50@lakeread06, "JMay"
wrote:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Then Exit Sub

here are a couple of ways:

Select A1:A10 and type BBB. But hit ctrl-enter instead of enter. You've filled
that range.

Copy A1:A10 to B1:B10 and you've got more than one cell.



JMay wrote:

Using
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Then Exit Sub

What kind of things (list most obvious) can happen to make this statement
TRUE?
TIA,

--

Dave Peterson

OK, Yes, got-em!!

"Dave Peterson" wrote in message
...
here are a couple of ways:

Select A1:A10 and type BBB. But hit ctrl-enter instead of enter. You've
filled
that range.

Copy A1:A10 to B1:B10 and you've got more than one cell.



JMay wrote:

Using
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Then Exit Sub

What kind of things (list most obvious) can happen to make this
statement
TRUE?
TIA,

--

Dave Peterson

Only selecting more than one cell and then changing the active cell to
trigger the event.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"JMay" wrote in message news:Jcflc.3306$nN6.50@lakeread06...
Using
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Then Exit Sub

What kind of things (list most obvious) can happen to make this statement
TRUE?
TIA,

Bob:

If I select more than one cell in my spreadsheet,
Let's say my cursor is in cell B1 and I drag over cells
to D5 (B1:D5 now selected) I'm unable to change the active cell, Right?
Are you talking about changing the active cell via code?
TIA,
JMay

"Bob Phillips" wrote in message
...
Only selecting more than one cell and then changing the active cell to
trigger the event.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"JMay" wrote in message
news:Jcflc.3306$nN6.50@lakeread06...
Using
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Then Exit Sub

What kind of things (list most obvious) can happen to make this
statement
TRUE?
TIA,

Hitting Tab will change the active cell within the selection.

--
Regards,
Tom Ogilvy

"JMay" wrote in message
news:Esqlc.3780$nN6.2939@lakeread06...
Bob:

If I select more than one cell in my spreadsheet,
Let's say my cursor is in cell B1 and I drag over cells
to D5 (B1:D5 now selected) I'm unable to change the active cell, Right?
Are you talking about changing the active cell via code?
TIA,
JMay

"Bob Phillips" wrote in message
...
Only selecting more than one cell and then changing the active cell to
trigger the event.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"JMay" wrote in message
news:Jcflc.3306$nN6.50@lakeread06...
Using
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Then Exit Sub

What kind of things (list most obvious) can happen to make this
statement
TRUE?
TIA,

Thks Tom, yeah I'd forgotten that (tidbit)!
So now that I go back and "tab" I see my activecell change
But no MsgBox

Using:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Then
MsgBox ("Statement is True")
End If
End Sub

What now?

"Tom Ogilvy" wrote in message
...
Hitting Tab will change the active cell within the selection.

--
Regards,
Tom Ogilvy

"JMay" wrote in message
news:Esqlc.3780$nN6.2939@lakeread06...
Bob:

If I select more than one cell in my spreadsheet,
Let's say my cursor is in cell B1 and I drag over cells
to D5 (B1:D5 now selected) I'm unable to change the active cell, Right?
Are you talking about changing the active cell via code?
TIA,
JMay

"Bob Phillips" wrote in message
...
Only selecting more than one cell and then changing the active cell to
trigger the event.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"JMay" wrote in message
news:Jcflc.3306$nN6.50@lakeread06...
Using
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Then Exit Sub

What kind of things (list most obvious) can happen to make this
statement
TRUE?
TIA,

I didn't suggest this action would fire an event. I just answered how to
change the activecell in a multi-cell selection.

for me, it fires neither change or selectionchange. Entering a value in the
active cell only produced a one cell target even with multiple cells
selected. Using Daves suggestion (multicell entry), it did fire a multicell
target (as expected). Deleting multiple cells did produce a multicell
target (as expected).

--
Regards,
Tom Ogilvy

"JMay" wrote in message
news:2Vqlc.3783$nN6.1057@lakeread06...
Thks Tom, yeah I'd forgotten that (tidbit)!
So now that I go back and "tab" I see my activecell change
But no MsgBox

Using:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Then
MsgBox ("Statement is True")
End If
End Sub

What now?

"Tom Ogilvy" wrote in message
...
Hitting Tab will change the active cell within the selection.

--
Regards,
Tom Ogilvy

"JMay" wrote in message
news:Esqlc.3780$nN6.2939@lakeread06...
Bob:

If I select more than one cell in my spreadsheet,
Let's say my cursor is in cell B1 and I drag over cells
to D5 (B1:D5 now selected) I'm unable to change the active cell,
Right?
Are you talking about changing the active cell via code?
TIA,
JMay

"Bob Phillips" wrote in message
...
Only selecting more than one cell and then changing the active cell
to
trigger the event.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"JMay" wrote in message
news:Jcflc.3306$nN6.50@lakeread06...
Using
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Then Exit Sub

What kind of things (list most obvious) can happen to make this
statement
TRUE?
TIA,

selecting multiple cells and hitting delete to clear them would be very
common.

--
Regards,
Tom Ogilvy

"JMay" wrote in message news:Jcflc.3306$nN6.50@lakeread06...
Using
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Then Exit Sub

What kind of things (list most obvious) can happen to make this statement
TRUE?
TIA,

Got It,
Tks,

"Tom Ogilvy" wrote in message
...
selecting multiple cells and hitting delete to clear them would be very
common.

--
Regards,
Tom Ogilvy

"JMay" wrote in message
news:Jcflc.3306$nN6.50@lakeread06...
Using
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Then Exit Sub

What kind of things (list most obvious) can happen to make this
statement
TRUE?
TIA,