check if cell is part of range

[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

 

[DNF Karran]

If Target.Count > 1 Then.......

Dunca

 

[DNF Karran]

Almost...

If Target.Column = 2 Then

I should really learn to read...

Dunca

 

[Frank Kabel]

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