User Form

B

Brad

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
 
B

Bob Phillips

Brad,

I get the value that I select from the Combo. I assume that the Combo is
called FilterPlease and you are clicking a value in it?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
B

Brad

I deleted the combo box, and put a new one on the form.
I did not change the name and it worked. I am not sure
what was wrong.

Thanks,

Brad
 
Top