If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

RE: row spacing in a userform listbox

Thread starter chazrab
Start date Oct 15, 2018
Tags

e.itemheight listbox1.measureitem row sender spacing

chazrab

Well-known Member

Oct 15, 2018

RE: row spacing in a userform listbox

Is it possible to increase the row spacing in a Listbox1 control on Userform1? The rows will decrease as the year progresses, if that makes any difference. Will this code work? (source:msdn). The font is highlighted in red when I copy and paste it into the Initialize method on the userform.

Code:

Private Sub ListBox1_MeasureItem(ByVal sender As Object, ByVal e As System.Windows.Forms.MeasureItemEventArgs) Handles ListBox1.MeasureItem
    e.ItemHeight = 30
  End Sub

or is there an easier, less obvious way ?
Thanks for anyone's help.
cr