hi,

i would like to have a combobox in my sheet where users select different
work locations. depending on which work location they select, the pivot
table in another sheet would show the corresponding detailed information. but
i would also like to have somewhere in another sheet a list of usrnames in
one column and passwords in another column, and work location in another
column. and when the user selects a work location using the combobox, the
code would evaluate whether or not the password matched that as typed in by
the user using an inputbox; if the password matched, the work location
details would be shown. how can this be done?

thanks in advance,
geebee