How to implement "select by location" by VBA and ArcObject ?

Discussion created by garysham on Feb 6, 2011
Latest reply on Feb 15, 2011 by kpayneesri-southafrica-esridist
Dear all,

I have two polygon feature classes, polygon A and polygon B.

I would like to write a VBA to perform a select by location function to find out which polygon(s) in polygon B is/are intersect with a selected polygon in polygon A which is selected by a user.

I know, I can use "ISpatialFilter" to do this, but don't know how to implement it in VBA. Would you mind provide some sample code/hints for me ?