As written, it doesn't scroll until the row number is beyond the visible
range. Then it centers that row vertically in the visible range. If you
don't have values out of view, it won't do anything. It isn't a smooth and
continuous scroll. As I said, there are many ways this could be
implemented - it really would require knowledge of what you are trying to
achieve. (which you have and I don't. )
--
Regards,
Tom Ogilvy
"Oreg " wrote in message
...
Tom,
Works Great!!! Thanks for taking the time to show me. I' can't get
the scroll bar to work..but that may be because I have combobox & text
box inside a frame...still working with it to see what the problem is.
I never thought I would get this far though. Can't thank you enough.
Bob,
That would be great. My email is Looking
forward to practicing with the workbook. Thanks for all the help!
---
Message posted from http://www.ExcelForum.com/