referencing ComboBox
 

hi guys

i have another question.

i use userform to filter data from the list. i have problem.
i use textbox and
1 is active
2 is completed
3 is withdrawn

eg when user puts 1 in textbox it just filters the user whose status is
1(active).
what i want is i want to use combobox which will show active, completed
and withdrawn. i dont want it to show numbers 1,2,3

what i mean is 1=active in combobox

thanks


---
Message posted from http://www.ExcelForum.com/

referencing ComboBox
 

'---------------------------------------------
Private Sub UserForm_Initialize()
ComboBox1.AddItem "Active"
ComboBox1.AddItem "Completed"
ComboBox1.AddItem "Withdrawn"
ComboBox1.ListIndex = 0
End Sub
'------------------------------------------
You find what has been selected with :=
x = ComboBox1.Valu

--
Message posted from http://www.ExcelForum.com