Removing vertical scrollbars on listbox
I don't think you can disable the vertical scrollbar in Excel for wither the
listbox or combobox. Here are a couple of ideas:
1. Hide the scrollbar by putting a label over it.
2. Hide the listbox. Display the current value of the listbox in a textbox.
3. Drop the listbox entirely. Hold the list of possible values in an array.
Use the spin button to move through the array and display one record at a
time in a textbox.
4. Maybe there is a fancier custom listbox control available that allows you
to suppress the scrollbar.
Hope this helps,
Hutch
"Webtechie" wrote:
I have a listbox that is just going to display one field and one line at a
time. I have a spin button that will iterate through the listbox values.
However, the listbox is showing a vertical scrollbar. How do I disable or
remove the vertical scrollbar? The vertical scroll is real small (since I am
only showing one line at a time) which is why I added a spin button.
Thanks,
Tony
|