check if cell is part of range

A

artemide

Hello everyone,


My question:

When a user clicks on a cell in column B (only this column) --> a form
should appear.
I created a Range-object myRange = Range("B:B").
I used the selectionChange-event to show the form.
But how can I check if the clicked cell is in this range ?

Thanks
 
F

Frank Kabel

Hi
alternative approach:
If Not Intersect(target,me.range("B:B")) is nothing then
'show form
end if
 
Top