| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Input Boxes 4 Inserting A Range In A Formula
I have the following piece of code for inserting a formula on a shortcut key
instead of typing the same manually. Sub InsertFormula() ActiveCell.Formula = "=sumproduct(--(a1:a10<0),b1:b10)" End Sub Any idea how to select the ranges: a1:a10 & b1:b10 via "Single" Input Box (like type:=8) with 2 fields for selecting the ranges? AND also via "Two" separate Input Boxes for the same purpose? -- Best Regards, FARAZ A. QURESHI |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting check boxes | Excel Discussion (Misc queries) | |||
| Inserting check boxes | Excel Discussion (Misc queries) | |||
| drop boxes, entering input | Excel Discussion (Misc queries) | |||
| Inserting check boxes | Excel Worksheet Functions | |||
| How do I add input data in the input ranges in drop down boxes. | Excel Discussion (Misc queries) | |||
Threaded Mode
