Drag and drop text in one click

[hoood]

Hi All,

I am struggling to find an elegant solution for drag and drop. My requirement is dragging some text from a 'menu' and dropping it in an excel cell in one click.
My current solution is using the web browser vba control and using hyperlinks as the 'drag and drop object' but it requires end users to make changes in the registry editor which is a big no no.

I am happy for the menu of text items to exist in a userform but the text must end up in the standard excel cells

thank you





drag and drop.png

[kev_]

If the value is in the active cell ...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Attach a shortcut to whichever macro does what you need

The input box allows the user to type in the destination cell address or to click on that cell

[hoood]

Is there a way to accomplish this with less clicks? At the very least, if I create a on selection change sub routine, this operation can be done with 2 clicks.
Is it possible to do it with one click? By dragging and dropping?

[kev_]

two options using event macros

Please Login or Register  to view this content.

[hoood]

Thank you Kev for your responses. However, both options still require the user to first click on the item they want to copy and then click on the destination, which is 2 clicks.
What I am looking for is a drag and drop experience

[kev_]

Another option
- click in range A2 to A1000 and copy that value to any cell clicked (here in range J2 to J1000)

Please Login or Register  to view this content.