ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Drag/resize an image on UserForm by the user (https://www.excelbanter.com/excel-programming/385445-drag-resize-image-userform-user.html)

avi

Drag/resize an image on UserForm by the user
 
Hello,

I'm looking for an example/approach for moving and resizing an image
displayed on a userForm, by the user (not in the design phase) by
directly interacting with the image, and not by providing parameters

Is it either doable?

Thanks a lot
Avi


JLGWhiz

Drag/resize an image on UserForm by the user
 
You could conceivably do it with code by putting a button on the form which
has preset parameters to unload the current form and redraw it to the preset
parameters. I don't know of a way to drag the changes, but then I'm not the
smartest guy on the block either.

"avi" wrote:

Hello,

I'm looking for an example/approach for moving and resizing an image
displayed on a userForm, by the user (not in the design phase) by
directly interacting with the image, and not by providing parameters

Is it either doable?

Thanks a lot
Avi



RB Smissaert

Drag/resize an image on UserForm by the user
 
Had a look at this some weeks ago and I think it is doable but very fiddly.

Catch the start of the move or re-size in the mouse_down event.
From the position of the cursor at the mouse-down decide if it is a re-size
or a move you want to start.
Do the move/resize based on the mouse movements.
Catch the mouse_up event and that will stop your action.

I thought it was too fiddly and left it, but if anybody has some nice code
for this then
I would be interested.

RBS


"avi" wrote in message
ups.com...
Hello,

I'm looking for an example/approach for moving and resizing an image
displayed on a userForm, by the user (not in the design phase) by
directly interacting with the image, and not by providing parameters

Is it either doable?

Thanks a lot
Avi



Michel Pierron

Drag/resize an image on UserForm by the user
 
Hi Avi,
Hope this help you
http://cjoint.com/?dqvK1h8ymy

Regards,
MP

"avi" a écrit dans le message de news:
...
Hello,

I'm looking for an example/approach for moving and resizing an image
displayed on a userForm, by the user (not in the design phase) by
directly interacting with the image, and not by providing parameters

Is it either doable?

Thanks a lot
Avi




RB Smissaert

Drag/resize an image on UserForm by the user
 
Very nice and thanks for posting that!
Needed to add On Error Resume Next to AxeX and AxeY.
Would there be any problem using this with a Frame?

RBS

"Michel Pierron" wrote in message
...
Hi Avi,
Hope this help you
http://cjoint.com/?dqvK1h8ymy

Regards,
MP

"avi" a écrit dans le message de news:
...
Hello,

I'm looking for an example/approach for moving and resizing an image
displayed on a userForm, by the user (not in the design phase) by
directly interacting with the image, and not by providing parameters

Is it either doable?

Thanks a lot
Avi





avi

Drag/resize an image on UserForm by the user
 
How nice and straightforward!!!!

Thanks a lot
Avi


RB Smissaert

Drag/resize an image on UserForm by the user
 
Would there be any problem using this with a Frame?

Yes, no trouble with that and as I only needed the drag I could leave some
code out.
Very nice bit of code.

RBS

"RB Smissaert" wrote in message
...
Very nice and thanks for posting that!
Needed to add On Error Resume Next to AxeX and AxeY.
Would there be any problem using this with a Frame?

RBS

"Michel Pierron" wrote in message
...
Hi Avi,
Hope this help you
http://cjoint.com/?dqvK1h8ymy

Regards,
MP

"avi" a écrit dans le message de news:
...
Hello,

I'm looking for an example/approach for moving and resizing an image
displayed on a userForm, by the user (not in the design phase) by
directly interacting with the image, and not by providing parameters

Is it either doable?

Thanks a lot
Avi







All times are GMT +1. The time now is 08:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com