Hi
within Excel I would use
application.inputbox
and use the type:=8
for this

--
Regards
Frank Kabel
Frankfurt, Germany


vikrantca wrote:
Hello,
Iam trying to write an activex control for charting, that shows some
prebuilt charts. I would like to use it in Excel.
How do I go about displaying a dialog box that asks the user for a
range of cells ?
Also, that control is already being used in VB - so how do I test is
the container is Excel - since I would want to ask for a range of
cells only when the container is Excel.

thanks in advance.
vikrantca