Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Congratulations GregLocock on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filtering the rowsource of a listbox

Thread starter -
Start date Mar 5, 2002

Status: Not open for further replies.

Mar 5, 2002

Guest

Hi

I have a form which when initialized it sets the rowsource of a listbox to a range on an excel worksheet.

I also have a combo box. When a value is selected in the combo box I would like to filter the listbox to what ever is in the combo box.

Each user has a permission. eg admin and I would like to filter just admin, or just something else.

This is the initialize part
LSTBOXUsers.RowSource = "Users!B2:E6"

Does anyone know how to go about this.

I hope someone an help

Thanks