Create a drag and drop list with shapes

[TheIntern]

Hello everyone,

I try to create a drag and drop list. The user should just be able to drag one of the shapes (named like processes) and drop it on 5 specific places.
Like that he should create a priority list.
Is it possible to restrict the places, where a shape can be dropped?

Thanks in advance,

the Intern

 

[DauntingGecko]

You're not making a lot of sense (to me)...can you explain what it is your trying to do in more detail?

 

[TheIntern]

Sorry, of cause!
I want the user to choose out of 10 options his top five solutions. Shapes containing the answers as text are next to the list.
Now the user should grab the first solution and put in into the first "gap"(meaning the first place, where it is possible to place the shape).
Then he should grab the second solution and put it into the second "gap".
It mustn't be possible to put the shapes (with the answers) anywhere else than in those "gaps"
Hope that is easier to understand.

 

[DauntingGecko]

OK. Get what you're doing but in Excel it would be a little fiddly to get it to look right. You're using the wrong technology for drag and drop type interface for a start (you want a slick looking front end like flash, silverlight or whatever apple can offer).

Within Excel (being a data orientated program and not really designed for graphics and motion) you'll be better off using a simple set of drop down menu's instead.

Not really what you want to hear I know. For drag and drop awesome "Apple like" front end stuff Excel isn't the best solution - you'll need to look into another type of software to meet your needs. Alternatively work another way such as using check boxes, drop down menu's, etc instead.

 

[TheIntern]

Your right, not what I wanted to hear^^
Anyway, thanks for your help, now I know it is not possible and have to find another solution.

 

[TheIntern]

Since it is not possible, thread can be closed.

 

[TheIntern]

Btw. I really hoped to find a solution, because I have to do it for work.
That's why I cross-posted in another forum, but I heard, thats not accepted. Sorry about that, I won't do it again!
http://www.ozgrid.com/forum/showthread.php?t=152049
http://www.excelforum.com/excel-general/770023-create-a-drag-and-drop-list-with-shapes.html