borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder

AndreaVB | Forum | News | Downloads | Register | Help | Member List | Statistics | Search | PM | Profile

Print This Topic
Previous Topic (manipulate row and column values in a loop)Next Topic (Date Function, 1st, 2nd Thursday ect..) New Topic New Poll Post Reply
AndreaVB Forum : VBA (Access, Excel, Word, ...) : Mouse wheel try #2
Poster Message
Yotzo
Level: Protégé

Registered: 06-08-2005
Posts: 4

icon Mouse wheel try #2

Hi!

As I see, there is a mbmouse.ocx that made to handle mouse wheel event.
Can someonetell me how can I call this, to be used in VBA from excel?

Thanks

07-08-2005 at 01:01 PM
View Profile Send Email to User Show All Posts | Quote Reply
steve_w
Level: Moderator


Registered: 18-04-2003
Posts: 1156
icon Re: Mouse wheel try #2

Hi

You should be able to add controls by adding a form in the vb editor then make sure the toolbox is visible and then under the "tools" menu you should be able to add "additional controls".

You may also want to look here

http://www.andreavb.com/forum/viewtopic.php?TopicID=4809&page=0#16045

Steve

10-08-2005 at 04:21 PM
View Profile Send Email to User Show All Posts | Quote Reply
Yotzo
Level: Protégé

Registered: 06-08-2005
Posts: 4
icon Re: Mouse wheel try #2

quote:
steve_w wrote:
Hi

You should be able to add controls by adding a form in the vb editor then make sure the toolbox is visible and then under the "tools" menu you should be able to add "additional controls".



Thanks for your help, now I have a new control on the toolbox, that I can drop to somewhere to a form, but when I pres F5 to see whats happening, I got a "run-time error 438 - Object doesn't support this property or methond" and then a "run-time error 429 - Activex component can't create object."
Thank you, for your answer. I hope you know the next step too :_)

quote:
http://www.andreavb.com/forum/viewtopic.php?TopicID=4809&page=0#16045


As in my previos topic I said, I tried that, what you linked, but I couldn't see an event, for the wheel


10-08-2005 at 06:46 PM
View Profile Send Email to User Show All Posts | Quote Reply
steve_w
Level: Moderator


Registered: 18-04-2003
Posts: 1156
icon Re: Mouse wheel try #2

if you want to zip the control up here, i'll have a look Friday, if I can. After that I'm on hols for two weeks  


Steve  

11-08-2005 at 04:25 PM
View Profile Send Email to User Show All Posts | Quote Reply
Yotzo
Level: Protégé

Registered: 06-08-2005
Posts: 4
icon Re: Mouse wheel try #2

I've downloaded it from
http://www.vbcity.com/mbgallery/default.asp?comp=mbmousehelper
Sadly, the source isn't free.

11-08-2005 at 09:11 PM
View Profile Send Email to User Show All Posts | Quote Reply
steve_w
Level: Moderator


Registered: 18-04-2003
Posts: 1156
icon Re: Mouse wheel try #2

Okay, mine did the same too . It did work in vb6 though, so don't know if anyone has any ideas why it should work in vb6 and not excel vba.


Steve

12-08-2005 at 12:14 PM
View Profile Send Email to User Show All Posts | Quote Reply
neutrall
Level: Master


Registered: 28-03-2004
Posts: 122
icon Re: Mouse wheel try #2

    I dont why, but I do know that  LOT of OCX doesn't work in VBA while they do work in VB6.

    I've learn this after many hour of trying to implement soe function into projects!

Daniel B.

____________________________
A Stick give a wise man something to think about... and a fool, something to put in is mouth.

13-08-2005 at 02:22 AM
View Profile Send Email to User Show All Posts Visit Homepage ICQ | Quote Reply
AndreaVB Forum : VBA (Access, Excel, Word, ...) : Mouse wheel try #2
Previous Topic (manipulate row and column values in a loop)Next Topic (Date Function, 1st, 2nd Thursday ect..) New Topic New Poll Post Reply
Surf To:


Not Logged In? Username: Password: Lost your password?
Partners: Download Actual Software | Free Software Download
borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder