filter combobox options

[zak.horrocks]

Hi there,

I am trying to filter combobox2 based on combobox1 in my userform.

What I would like is if in combobox1 "draft" is selected from the list then in combobox 2 the list will only show authors who have work at a "draft" level. My data is in sheet1.

Many thanks

Z

[Tinbendr]

You're workbook didn't attach.

What you want is a cascading combobox, or dependant combobox. Here are several messages with that topic.

If you still need help, please post your workbook using the Manage Attachments under the Go Advanced button.