Thanks for reading my question

I have a for that I made in the VB environment. It has a
combo box that I want to retrieve the value from.

The rowsource is set to a named range on the workbook
sheet. It is a list of names.

How do I get the value of the combo box. Right now all I
get is 0 or False.


Thanks again,

Brad

Private Sub FilterPlease_Click()
Dim FilterValue As String
FilterValue = Me.FilterPlease
MsgBox FilterValue
Range("A7").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
'Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:=FilterValue
Range("E7").Select
End Sub