Posted to microsoft.public.excel.misc

FARAZ QURESHI FARAZ QURESHI is offline

external usenet poster

Posts: 553

Inputbox for a formula

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
InputBox	peyman	Excel Discussion (Misc queries)	4	September 28th 07 04:53 PM
InputBox	GeorgeJ	Excel Discussion (Misc queries)	5	July 12th 07 01:20 AM
inputbox	brownti via OfficeKB.com	Excel Discussion (Misc queries)	2	February 9th 07 02:37 PM
msgbox / inputbox etc	samenvoegen van sheets	Excel Worksheet Functions	2	March 15th 06 04:28 PM
Inputbox with VBA	Jeff	Excel Discussion (Misc queries)	3	January 19th 06 05:18 PM

All times are GMT +1. The time now is 12:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us