DragDrop onto a selected range

[Guest]

I am creating an application which is addin to Excel. I am trying to dragdrop
a value from a form (which is Excel Addin Form) into selected Excel cells;
but the drag dropped value is being dropped to only one cell - but not to all
the selected cells.

Is this normal Excel behavior?

Any ideas to implement this? Any help is really appreciated.

Thanks!!

 

[Chip Pearson]

From what type of control are you dragging/dropping?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Guest]

I created a form ( a treeview display of some data)which can be opened from
Excel custom menu bar... trying to drag a value from a treeview onto selected
Excel range.

This is what I am trying -

1. I open Excel and click on "xx" menu (created custom menu); which loads
some data and displays treeview representation of that data...
2. I am selecting some contigious cells on Excel and trying to drag data
from treeview onto selected range - but the data is seen only one one cell
which got focus when dragging...

Is it possible to keep track of that selected range. BTW, my treeview form
has access to the Excel application object.