Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
avi avi is offline
external usenet poster
 
Posts: 195
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,452
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 214
Default 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



  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,452
Default 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






  #6   Report Post  
Posted to microsoft.public.excel.programming
avi avi is offline
external usenet poster
 
Posts: 195
Default Drag/resize an image on UserForm by the user

How nice and straightforward!!!!

Thanks a lot
Avi

  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,452
Default 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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I can't select, move or resize an image in Excel?? Michael Howes Excel Discussion (Misc queries) 3 April 2nd 23 07:40 PM
Resize image using macro Gotroots Excel Worksheet Functions 1 November 12th 09 11:04 PM
auto resize when insert large image to excel sajid Excel Worksheet Functions 4 November 21st 06 03:40 PM
resize userform image to fit on any monitor timspier[_7_] Excel Programming 1 August 5th 06 06:44 AM
resize my userform MD Excel Programming 8 May 14th 05 03:16 PM


All times are GMT +1. The time now is 03:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"