Excel builtin form to select cell range? 1

[kphu]

Hey,

Does anybody know if its possible to use the built in form that selects a cell range in from excel? I always see it when you need to select a cell range but I don't know what the form is called. I checked applications.dialogs and can't find it?

Example: I always see it when you create charts and it asks you for the X and y data series or if you run a macro and under the macro name there's a little icon that you press to bring up a form that allows you to select a cell range.

Thanks,
Ken

 

[SkipVought]

Check out the InputBox Method.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[kphu]

Fully aware of inputbox. The issue with the inputbox method is that the user would have to type in the text and doing error control on that is a pain.

 

[SkipVought]

"...the user would have to type in the text ..."

Not so. Read you HELP on this!

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[xlbo]

Skip's approach will probably work but the control you are asking about is the REFEDIT control

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[kphu]

Geoff,

That's exactly what I was looking for. here's your xmas present *.

 

[kphu]

For everybody else - Merry XMAS and Happy New Years!