How to use SystemParametersInfo to Get SPI_SETWHEELSCROLLLINES

Hello... To everyone...

I'm working on a database in excel ... (Obvious) ... and i had to increase the height of rows to 90,75 (121px)
after that it only let me view 2 lines (Rows) at a time (Screens).

And every time i scroll the mouse wheel, it will jump to 3 by 3 rows, and a need to change the mouse settings to jump to 1 by 1 row (Line),
i know i can go to control panel => Mouse => Wheels => change parameters of 3 lines to 1.

OK,... but how to do this without having to go all the times to control panel,
and if someone else is using this database not have to go through hassle of doing constantly the same operation.

So i have did a research in how it would be possible to do this with Visual Basic ...
and i found this;

http://msdn.microsoft.com/en-us/libr...=vs.60%29.aspx

and this;
http://vcpptips.wordpress.com/tag/sp...elscrolllines/

and in other sites of this type, they mention this type of code must be place in VB-MODULE...?!

Now, i have no idea in how to use this or how to develop this type of code.

Can someone help me in this... please.

Originally Posted by martindwilson

i wouldn't let any spread sheet run on a machine of mine that could change system settings like mouse scroll

Yea... i understand that... It's dangerous, virus, ad-ware, spy-ware, etc.

But... in a database that is needed to scroll line by line, and it scrolls 3 lines by 3,
and every time that database is open the user has to go to panel control to change mouse scroll, and when it exit have to go back to set back settings.
Because to scroll in the web-site it is need to be 3 by 3 its more used.

It's quite a bit annoyed

cross post
http://www.mrexcel.com/forum/showthr...EELSCROLLLINES

JosephP I thank you very much for your reply.

I will give it a try then i will feedback about the result.

But... First of all... before this thread go furthermore, i have to apologize to all users and moderators of this forum so i may have some peace of conscience.

When i post this thread i have made the little big mistake of CROSS-POST this same thread in others forums has well.

This action of mine has by the reason of desperate in quickly get an answer for a work that i had been hand delivered by my class teacher, and it was to be made with limited time to deliver it.

The unforgivable was... the fact that neither occurred to me to check the forum rules, about using with courtesy the method CROSS-POST.

This small gap is quite disrespectful to all users who voluntarily devote their time to help those who little or nothing understand of this matter.

So... this will be has a future example to all of those, who someday decide to do something similar, just don't, the rush to get quick results only originates accumulated disasters.

The posts in question, which have been mentioned above are placed in the following boards;

http://www.mrexcel.com/forum/showthr...78#post3195378

http://www.ozgrid.com/forum/showthre...900#post615900

_CYBERPATH_

Originally Posted by JosephP

basically in a normal module (in other words not worksheet/workbook/class/userform):

Please Login or Register  to view this content.

Thanks JosephP for your reply, i have put the code in a new MODULE window, but it doesn't have no effect.
I'm using Office 2010, in windows seven (NOT SP1).

the only options a have found so far was this;

Please Login or Register  to view this content.

Anyway, thanks, i have delivered my work, now it's just only by mere curiosity ....