Drag and drop event

[Dantz]

Good day!

I'm doing a drag and drop in a worksheet...I have a userform with a
listview, then I have to drag names from the listview and drop it into
a specific cell in a worksheet...i'm having problems when I drop a name
into a merge cells, and have this message--"Data on the clipboard is
not the same size and shape as the selected area"...and when I click
"OK" another error is displayed--"Cannot change part of a merged
cell"...I am using a template so I can't just change those cells..I
also used the "Center Across Selection" alignment but its not good when
you have cells side by side and you edit the first cell, the data will
scatter along with the cells that have same alignment...I really need
on how can I trap the drop event in the worksheet..please help
me...thank you in advance

 

[Guest]

I have never used a list view control - however I'm not sure that it works on
Excel sheets. usually, getting data from auserform to any user selected cell
would require the RefEdit control.

 

[Dantz]

Thanks for the response. I have set the property of the listview to
OLEDragAutomatic...then the worksheet just automatically accepts a
value from the listview but with single cell only. I'm having problems
when the cell to drop off is a merge cell...is there a way to determine
if a cell is merged even before it trigger the worksheet_change?