Drag and Drop in user forms

  • Thread starter Thread starter Roger on Excel
  • Start date Start date
R

Roger on Excel

I use userforms for data entry and data editing.

Is it possible to drag and drop text around in a userform?

My userforms allow me to select text but i cant move it to another adjacent
cell by dragging it.

Can anyone help?
 
I think this is what you want. I assume you want to move text from one text
box to the next on a Userform. Select the text in the textbox then hit Ctrl
C to copy it, then select another textbox and hit Ctrl V to paste it.

Is this what you wanted?
 
TextBox1.DragBehavior = fmDragBehaviorEnabled

Where/when you want to enable drag/drop is up to you, maybe at design time,
the form's initialize event, or perhaps the textbox's mousedown event if say
right button pressed. Then you might want to disable. Note if you allow drag
with the left button onto a cell you will "move" the text. You might first
need to put the text in the DataObject so you can restore it to the textbox
if necessary. With right drag a popup should appear on drop.

Also of course you'll need to show the form modeless if you want to drag
into a cell.

Regards,
Peter T
 
Back
Top