SelectionChange works only when Cellpointer is within a given rang

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I only want the SelectionChange event to run if the Cellpointer is within
the range B5:G11, or probaby better referring to B5:G11 as a Range name

EG If Target.Address is within the range B5:G11 then run the SelectionChange
event!

Hope that makes sense to someone.

Thanks

John
 
You can use the intersect method something like this...

if not intersect(target, Range("B5:G11")) is nothing then
msgbox "Bombs Away..."
end if
 
Cool, thanks Jim.

Jim Thomlinson said:
You can use the intersect method something like this...

if not intersect(target, Range("B5:G11")) is nothing then
msgbox "Bombs Away..."
end if
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unload a Form using SelectionChange 5
cell value 2
Change_Event target either of two cells 20
Returning the position of the Cellpointer in the range 2
VBA set thick borders around non empty cells in range 0
Trigger Event Sub when A1 <> B1 4
Need to find particular string within cell text, if found a value is copied 4
Active Workbook from User Form 1

Back
Top