I want to be able to drag a name from a list and drop it into a cell, I don't want to use the inbuilt drag and drop as if I do this it copies across the original cell format and the copy and paste values is a bit beyond some others who have to use the worksheet.
Is there a way to do this in...