Drag and Drop Cell contents into UserForm Textbox ?

[Jaafar Tribak]

Hi all,

I have a modeless userform with a textbox in it .. I would like to be able to drag and drop cells into the textbox but excel doesn't allow the drag and drop operation .. instead, the cell content is dropped into the cell right behind the userform textbox .. the DragBehavior Property of the textbox is set to True although this wouldn't make any difference in theory

I would like to know if i am missing something before I take this further

Regards.

 

[Jaafar Tribak]

Ok, this does copy the cell content onto the textbox .. I'll see if I can prevent the cell underneath from pasting the contents as well

Private Sub TextBox1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
    Me.TextBox1.Text = Selection
End Sub