Drag frames

[charly1]

Hi excel pros

I have a user form with a couple of frame controls. I am trying to enable a mouse drag feature that would enable a user, to swap the positions of any two frames by dragging one of them and releasing it over the other. [In my specific case each frame in the user form is entirely filled with controls - not sure if that makes a difference].

I need this to work specifically for frame controls [not all the frames on my user form though], and to allow dragging only to swap positions between frames - like I said by dragging one over to the other.

I have been googling around for ages, and have seen various drag ideas but none for swapping positions.

If it can be done I would really appreciate any help that can be offered. [If it can't be done, I would also appreciate being told as much, so that i shouldn't waste any more time over it.

Thank You so much in advance

 

[Herakles]

Hi excel pros

I have a user form with a couple of frame controls. I am trying to enable a mouse drag feature that would enable a user, to swap the positions of any two frames by dragging one of them and releasing it over the other. [In my specific case each frame in the user form is entirely filled with controls - not sure if that makes a difference].

I need this to work specifically for frame controls [not all the frames on my user form though], and to allow dragging only to swap positions between frames - like I said by dragging one over to the other.

I have been googling around for ages, and have seen various drag ideas but none for swapping positions.

If it can be done I would really appreciate any help that can be offered. [If it can't be done, I would also appreciate being told as much, so that i shouldn't waste any more time over it.

Thank You so much in advance

Why not just makeit simpe,and have a Command Button that has code that changes the position of the frames and controls? Keep it simple and move on to the more important tasks.

 

[charly1]

Well there are many frames. I am assuming that it can be done somehow, and dragging would definitely be the most user-friendly way for it to be done. Your right there are more important tasks, and I don't expect the help, I would appreciate it though.

 

[My Aswer Is This]

Well there are many frames. I am assuming that it can be done somehow, and dragging would definitely be the most user-friendly way for it to be done. Your right there are more important tasks, and I don't expect the help, I would appreciate it though.

You could use a script to move the Frames.
Something like Frame1 .left=23