Hi,
This code makes me see the list in the userform, however it is also showing the zeroes (as a result of formula).I desire not to see the zeroes in the list as it crowds the list and is pains the eye. Can somebody re-write the code for me to just hide the zeroes from view?
Thanks!
This code makes me see the list in the userform, however it is also showing the zeroes (as a result of formula).I desire not to see the zeroes in the list as it crowds the list and is pains the eye. Can somebody re-write the code for me to just hide the zeroes from view?
Thanks!
Code:
Private Sub CommandButton3_Click()
Dim lbtarget As MSForms.ListBox
Dim rngSource As Range
'Set reference to the range of data to be filled
Set rngSource = Sheet3.Range("A11:BG350")
'Fill the listbox
Set lbtarget = UserForm3.ListBox2
With lbtarget
.ColumnHeads = False
'Determine number of columns
.ColumnCount = 59
'Set column widths
.ColumnWidths = "40;60;140;0;65;0;0;30;0;0;0;0;0;0;0;0;40;0;0;30;0;0;0;0;0;0;0;0;40;0;0;30;0;0;0;0;0;0;0;0;40;0;0;30;0;0;0;0;0;0;0;40;30;0;35;0;35;35;35;35"
.List = rngSource.Cells.Value
End With
End Sub