How do I initiate a user input of a range of cells after clicking a
visual object? I want the program to pause whilst the user selects a
range of cells on the worksheet whcih will be used later to input a
file directory.

I appreciate any help.

Thanks Naim.