PC Review


Reply
Thread Tools Rate Thread

Drag/resize an image on UserForm by the user

 
 
avi
Guest
Posts: n/a
 
      16th Mar 2007
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 With Quote
 
 
 
 
=?Utf-8?B?SkxHV2hpeg==?=
Guest
Posts: n/a
 
      16th Mar 2007
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
>
>

 
Reply With Quote
 
RB Smissaert
Guest
Posts: n/a
 
      16th Mar 2007
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 With Quote
 
Michel Pierron
Guest
Posts: n/a
 
      16th Mar 2007
Hi Avi,
Hope this help you
http://cjoint.com/?dqvK1h8ymy

Regards,
MP

"avi" <(E-Mail Removed)> a écrit dans le message de news:
(E-Mail Removed)...
> 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 With Quote
 
RB Smissaert
Guest
Posts: n/a
 
      17th Mar 2007
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" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hi Avi,
> Hope this help you
> http://cjoint.com/?dqvK1h8ymy
>
> Regards,
> MP
>
> "avi" <(E-Mail Removed)> a écrit dans le message de news:
> (E-Mail Removed)...
>> 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 With Quote
 
avi
Guest
Posts: n/a
 
      17th Mar 2007
How nice and straightforward!!!!

Thanks a lot
Avi

 
Reply With Quote
 
RB Smissaert
Guest
Posts: n/a
 
      17th Mar 2007
> 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" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> Hi Avi,
>> Hope this help you
>> http://cjoint.com/?dqvK1h8ymy
>>
>> Regards,
>> MP
>>
>> "avi" <(E-Mail Removed)> a écrit dans le message de news:
>> (E-Mail Removed)...
>>> 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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
userform - user selects image file from dir that will display in c est Microsoft Excel Programming 0 8th Nov 2009 10:30 PM
userform - user selects image file from dir that will display in c est Microsoft Excel Programming 0 8th Nov 2009 10:28 PM
resize userform image to fit on any monitor timspier Microsoft Excel Programming 1 5th Aug 2006 06:44 AM
Let User Drag to Re-Size Image =?Utf-8?B?QUNhdW50ZXI=?= Microsoft ASP .NET 6 1st Mar 2005 12:19 AM
How to Resize Userform? hce Microsoft Excel Programming 0 24th Oct 2004 01:19 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:04 PM.