Removing the vertical scrollbar in a listbox

azizrasul

Well-known Member
Joined
Jul 7, 2003
Messages
1,263
I have a listbox on a userform where the data comes from a worksheet in which there will only be a maximum of the three rows plus the header. I have created the listbox so that the maximum of 3 rows of data can appear. However the vertical scrollbar appears on the userform.

How can I remove this?

If I make it vertically longer then the scrollbar does dissappear, but it looks odd and takes up valuable space on the form.
 
Last edited:

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

EXCEL MAX

Active Member
Joined
Nov 11, 2020
Messages
380
Office Version
  1. 2007
Platform
  1. Windows
Your listbox rowsource property includes more the 3 rows. For example RowSource is "Sheet1!A1:B50" instead "Sheet1!A1:B3".
 

Watch MrExcel Video

Forum statistics

Threads
1,126,986
Messages
5,621,992
Members
415,873
Latest member
fuulhouse

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top