User Form - frame scroll with wheel mouse and cut & paste from tex

I have created a user form in excel 2003, I have a frame that has a verticle
scroll bar. I need some code to make the wheel mouse work on the frame. I
cannot use a thirdparty program. It has to be coded in excel. I have tried a
couple of examples of api code and failed. Can some one help me? Also I need
to know how I could right click on a text box on the form and cut & paste to
other applications. THANKS IN ADVANCE!!!!

qaform = name of form
frmmain = name of frame to scroll

Hi Kenjaro,
How about use a DLL that available on MS site?
I think it's the easiest way.

Mouse wheel events do not work in the Visual Basic 6.0 IDE
http://support.microsoft.com/kb/837910/EN-US/

If you really would like to write a code in Excel VBA alone, you need search
it in MSDN site.

--
Regards,
Colo
http://www.puremis.net/excel/


"Kenjaro" <[email protected]> wrote in message
news:[email protected]...
> I have created a user form in excel 2003, I have a frame that has a
verticle
> scroll bar. I need some code to make the wheel mouse work on the frame. I
> cannot use a thirdparty program. It has to be coded in excel. I have tried
a
> couple of examples of api code and failed. Can some one help me? Also I
need
> to know how I could right click on a text box on the form and cut & paste
to
> other applications. THANKS IN ADVANCE!!!!
>
> qaform = name of form
> frmmain = name of frame to scroll
>
>

Hi Kenjaro,
right click on a text box and cut & paste

Private Sub TextBox1_MouseDown _
(ByVal Button%, ByVal Shift%, ByVal X!, ByVal Y!)
If Button = 2 Then
With Me.TextBox1
..SelStart = 0: .SelLength = Len(.Text)
'.Copy
..Cut
End With
End If
End Sub

select other application and paste.
MP


"Kenjaro" <[email protected]> a écrit dans le message de
news:[email protected]...
> I have created a user form in excel 2003, I have a frame that has a
verticle
> scroll bar. I need some code to make the wheel mouse work on the frame. I
> cannot use a thirdparty program. It has to be coded in excel. I have tried
a
> couple of examples of api code and failed. Can some one help me? Also I
need
> to know how I could right click on a text box on the form and cut & paste
to
> other applications. THANKS IN ADVANCE!!!!
>
> qaform = name of form
> frmmain = name of frame to scroll
>
>

Well because it dosent work with vb editor in excel. Tried it. It dosent work



"Colo" wrote:

> Hi Kenjaro,
> How about use a DLL that available on MS site?
> I think it's the easiest way.
>
> Mouse wheel events do not work in the Visual Basic 6.0 IDE
> http://support.microsoft.com/kb/837910/EN-US/
>
> If you really would like to write a code in Excel VBA alone, you need search
> it in MSDN site.
>
> --
> Regards,
> Colo
> http://www.puremis.net/excel/
>
>
> "Kenjaro" <[email protected]> wrote in message
> news:[email protected]...
> > I have created a user form in excel 2003, I have a frame that has a
> verticle
> > scroll bar. I need some code to make the wheel mouse work on the frame. I
> > cannot use a thirdparty program. It has to be coded in excel. I have tried
> a
> > couple of examples of api code and failed. Can some one help me? Also I
> need
> > to know how I could right click on a text box on the form and cut & paste
> to
> > other applications. THANKS IN ADVANCE!!!!
> >
> > qaform = name of form
> > frmmain = name of frame to scroll
> >
> >
>
>