referring to selection from multi-select userform

[kidkarma]

Hi,

I have a multiselect userform whereby the user chooses values that are
sourced from a headings on a worksheet.

The values that are chosen I would like to show, but the values that
aren't I would like to hide the entire column.

I'm really not enjoying vba at the mom.

Here is the code which i keep getting 'object required'

Private Sub CommandButton1_Click() 'This is the code linked to the
'ok' button on the multiselect userform

Rng = Sheets("BS Method").Range("Filter_Entname").Columns.Count - 2
RngCellValue = Sheets("BS Method").Range("Filter_Entname")
StartCell = Sheets("BS Method").Range("E9")
Application.ScreenUpdating = False
For i = 1 To Rng
If StartCell.Value <> ListBox1.Selection Then
Selection.EntireColumn.Hidden = True
Else
StartCell.Offset(0, 1).Select
End If
Next i
Application.ScreenUpdating = True
End Sub

Sorry for posting such 'beginner' questions

Thanks

 

[Greg Glynn]

Try Hiding all the columns and then only showing the ones selected.