Using Worksheet_SelectionChange

[mpadgett]

I'm trying to use Worksheet_SelectionChange to identify if a user selects cells F4 through F30 to thus execute a macro but I'm having some difficulty with the syntax to define the F4:F30 range. Thanks for any help.

 

[SkipVought]

Hi,

  if target.count>1 then exit sub

  if not intersect(target, range("F4:F30")) is nothing then
     'do stuff here
  end if

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[PHV]

identify if a user selects cells F4 through F30
If Target.Address = Range("F4:F30").Address then
MsgBox "user selects cells F4 through F30"
end If

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[mpadgett]

Sorry, I meant to state that I need to identify if a user selects a cell within F4 through F30 not all of the cells from F4 through F30. Thanks,

 

[SkipVought]

Did you try it?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

it is exactly what my code does.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[mpadgett]

I did try and your code and it worked perfectly if I select all cells from F4 through F30. As I mentioned in my reply, I'm actually wanting to evaluate if a user selects a cell within F4:F30. Thanks,

 

[SkipVought]

I'm actually wanting to evaluate if a user selects a cell within F4:F30.

This is EXACTLY what my code does!

Whenever you select ONE CELL within F4 - F30 the code will execute WHATEVER you put following 'do stuff here

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[mpadgett]

Your MsgBox is only being activated when I select all cells from F4 to F30. When I select anything less that that, I get nothing.

 

[SkipVought]

I DON'T HAVE A MSGBOX!!!!

That was PHV's code.

Focus!

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

Please do not fail to respond back to resolve your thread, as you have displayed an anoying habit of not doing so, over the past 5 years.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[mpadgett]

Skip:

You're correct. My appologies! Your code works beautifully. Thank you,