Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How nice and straightforward!!!!
Thanks a lot Avi |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I can't select, move or resize an image in Excel?? | Excel Discussion (Misc queries) | |||
Resize image using macro | Excel Worksheet Functions | |||
auto resize when insert large image to excel | Excel Worksheet Functions | |||
resize userform image to fit on any monitor | Excel Programming | |||
resize my userform | Excel Programming |