Dialogs - Select Range Form

[kphu]

Hey,

Does anybody if its possible to show the built in form select 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?

 

[bubba100]

In Excel this works. It is not exactly the same.
Dim Message, Title, Default, MyValue
Message = "Enter a Range R*C*:R*C* " ' Set prompt.
Title = "InputBox Demo" ' Set title.
Default = "" ' Set default.
' Display message, title, and default value.
MyValue = InputBox(Message, Title, Default)

Application.Goto Reference:=MyValue '"R1C1:R5C4"

 

[kphu]

yeah I'm fully aware of inputbox and have used it many times. I was just curious how one would go about finding these idiosyncrysis of excel.

Thanks,

 

[bubba100]

The macro recorder helps.

 

[kphu]

yeah I use the macro recorder all the time too but it doesn't capture the advance stuff i'm interested in. the issue with the input box is that you have to type in the values as oppose to highlighting the range of cells you want using the built in form.

 

[PHV]

Straight from the Excel VBA help:
Set myRange = Application.InputBox(prompt := "Sample", type := 8)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886