Hello Everyone:

I am emailing this question from work, so I apologize I did not have the
opportunity to do a through search for answer through the forum. I did a
quick one but did not find my answer and thus this post. Thanks in advance
for any assistance.

I am writing a VBA macro in which I would like to have a cell selection
dialog to pop up for the user. I do not know if this is the correct name for
what I am looking for, but you can see this when you use the Function Wizard
in Excel or when you make a PivotTable and Excel prompts you for data range.
Any quick leads would be all I need. It usually looks like a Text Box
control with a little button at the right side which when you click it you
can navigate the spreadsheet to select your cell or range or cells.

Any leads would be great or even a listing of the method on an object to
generate this box (if possible) would be great. Again, thanks in advance.

Amar