I am not sure what you mean. They can already drag and drop if the worksheet is not protected and cells are unlocked.

You can use Application.Input with the type as 8 to let them pick a range.

If you are in a userform, you can set the ShowModal property to False or set it when you Show it.