• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 790
  • Last Modified:

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.

Joe
0
borgtamer
Asked:
borgtamer
  • 2
1 Solution
 
Jerry MillerCommented:
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.


http://www.excelforum.com/excel-general/642265-floating-text-box.html
0
 
Chris Raisin(Retired Analyst/Programmer)Commented:
I'm working on this Joe...Standby
0
 
Rory ArchibaldCommented:
Why make the listbox into a textbox? You can add a listbox to a userform just as easily.
0
 
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.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now