"Syed Zeeshan Haider" wrote in
message ...
Hello Experts,
I have Excel 97 Pro on Win98SE.

I guess there is a control available in VBA for Excel (similar to Formula
Palette), which we can use to let the user chose a range for macro. I am
attaching the image (ctl.bmp, 886 bytes) of its typical recognition. My
questions a
What is the name of this control?
How to appear it?

A macro, written by me, needs a range for running but the user has to type
the range in InputBox which is not very wise to me.


If you use the type argument with input box you can select
a range using the mouse

Dim temp_range as Range
Set temp_range = Application.InputBox(prompt:="Select Range for Operation",
Type:=8)

Keith