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 i
1(active).
what i want is i want to use combobox which will show active, complete
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