Inputbox for a formula

F

FARAZ QURESHI

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
 

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

Top