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 Excel? I have experimented with a list box but I am not sure if I can do this or what the code would be.
Is there a way to do this in Excel? I have experimented with a list box but I am not sure if I can do this or what the code would be.
