Removing the vertical scrollbar in a listbox

[azizrasul]

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.

 

[EXCEL MAX]

Your listbox rowsource property includes more the 3 rows. For example RowSource is "Sheet1!A1:B50" instead "Sheet1!A1:B3".

 

[azizrasul]

Your listbox rowsource property includes more the 3 rows. For example RowSource is "Sheet1!A1:B50" instead "Sheet1!A1:B3".

Now why didn't I think of that. Many thanks.