ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   scroll records with distinct value in column (https://www.excelbanter.com/excel-programming/405264-scroll-records-distinct-value-column.html)

sal21

scroll records with distinct value in column
 
Have a sheet filled with variuos rekords...(started from line 2 range
A2:Y & last filled cell)
Have a userform with variuos tetx box fille from value in column of
range.
Have a combobox filled with "AAAA"
Now in column Y of sheet are present value similar:

J2 AAAA
J3 AAAA
J4 AAAA
.....

J2 BBBBB
J3 CCCC
J4 CCCC

Now using a scrollbarchange1 event how to scroll only the line of
sheet based value in comboxbox and column Y?
Naturally use scrollbarchange in up and down...


All times are GMT +1. The time now is 09:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com