What would be the most appropriate code for selecting a range and then being
used.

Suppose I want a forulma e.g.
(Sample only)
=sumproduct(--(range1<0),range2)

In such a case I need an input box to popup asking for two ranges to be
selected and then insert the formula on the active cell instead of having the
complete statement being typed.

Thanx in advance

--
Best Regards,

FARAZ A. QURESHI