Indicate by Prompt and Click

Much of my code operates on a user selection. Usually they work by producing descriptive prompts in the very beginning or descriptive buttons that make clear what kind of selection is appropriate for the macro to execute succesfully. This works great when only a single selection is enough to complete the task.

I'm running into situations lately where it would be really nice to prompt the user for a second range midway through macro execution. How can this be done? If I were to give the function I'm looking for my own name it would be something like getUserIndictatedObjectByClick and it would return an object and have an option to send the user a prompt describing the expected return object.

Is there something like that built into VBA or can I create a control that accomplishes this? I've not used controls before so this is what I'm currently researching.

Thanks,

Kyeohti

You can use a simple inputbox ! Check this out:


Dim myRange As Range
Set myRange = Application.InputBox(prompt:="Select a range:", Type:=8)


This allows user to highlight a range and it will fill out the input box. Make sure to add error handling code of course!

More info here:
http://msdn.microsoft.com/en-us/library/aa195768(office.11).aspx