How to use a Scroll bar (form control)

**RA_Lek** · 07-06-2013, 10:01 PM

Hi All,

I have an excel file with 2 tab sheets, Raw & Search. On the search tab, you can see there's a filter category based on month & fruits. So, it will return all the data based on those categories. My question is, how to incorporate the scroll bar (form control) on my search tab? Because the list is getting longer and I want to minimize the view of the sheet.

Thank you!

**AlKey** · 07-06-2013, 11:05 PM

I am not sure how you want to use your filters but for the scroll bar I suggest to use ActiveX control. You would need to changes settings for properties. Such as Max (number of rows: should be total rows of the data table minus number of rows dedicated to control by scroll bar), Small Change (usually 1), Linked Cell (cell where scroll bar will write a value of the row to be offset) and you would need to use OFFSET function.

**RA_Lek** · 07-07-2013, 11:18 PM

Hi AlKey,

The scroll bar works perfectly! However, the filter function on the Search tab (2 criteria based on month & fruits) is no longer working. I want to have both functions (filter and scroll bar) working on the said sheet. Is that possible?