Keep Listbox at top of Scrolling Worksheet

I have a worksheet with about 300 rows x 2 columns, A and B. I also have a listbox with information in Column C

How can I keep the listbox visible while I am scrolling the worksheet? Right now it scrolls with the worksheet and quickly cannot be seen. I want it to stay in the viewing area of the scrolling worksheet.
Here is an image of the basic sheet:
 Initial View
Here is another image of the worksheet half hidden during scrolling.
 View after scrolling
I want the ListBox to remain visible during the time the worksheet is scrolling. Any idea how to do this with VBA?

Thanks in advance.

Who is Participating?
Jerry MillerConnect With a Mentor Commented:
This may be of use to you. Make the listbox into a textbox control on a form and set the Modal property of the form to false.
Chris Raisin(Retired Analyst/Programmer)Commented:
I'm working on this Joe...Standby
Rory ArchibaldCommented:
Why make the listbox into a textbox? You can add a listbox to a userform just as easily.
Jerry MillerCommented:
You're right rorya, you can simply use the listbox control on a form and it works just as well. I was following the example I found without thinking it through completely. The form will 'float' in the area you set it and not roll up as you scroll down.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.