删除列表框上的滚动条 [英] Remove the scroll bar on a list box

问题描述

我在vba中使用userForm，并且有一个列表框.我要删除horoz.底部的滚动条.有没有办法做到这一点?我在属性框中看不到任何选项.

I'm using a userForm in vba and I have a list box. I want to remove the horoz. scroll bar from the bottom. Is there a way to do this? I don't see any option in the properties box.

推荐答案

当您将列表框的列宽格式属性设置为某宽，然后将控件的大小调整为数据大小时，就会发生滚动酒吧.

This can occur when you have the column width format property of the listbox set to something wide, then you size the control to the data, it will show the scroll bars.

要解决此问题，请将格式"选项卡下的列宽"属性更改为很小，然后使用此属性和列表框控件的大小，直到获得所需的效果，并且不会显示滚动条

To fix this, change the "Column Width" property under the format tab to something really small, then play around with this property and the size of the listbox control until you get it how you want, and no scroll bars are displayed.

这篇关于删除列表框上的滚动条的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！