I have a userform that I created in Excel. Row widths can increase considerably depending on the amount of data entered by the user. However, the wider the line spacing, faster you scroll down to the next line/cell with the mouse wheel (Because it skips/jumps to the next line without fully displaying the previous line/cell, so the entered information in the previous line/cell cannot be read). Is there any way to slow down/adjusting the scrolling pace in accordance with the line width by using vba code?
I'm expecting to get more readable userform by lowering/adjusting the pace of scrolling down for the lines between 3-28. I used below code but for some reason it did not give the result i expect.
Worksheets("sheet1").Activate
ActiveWindow.SmallScroll down:=1