Listboxes on a worksheet
 

Hi, I don't know if I'm using the optimum approach...

What I want is have an order pad. I have on the only visible sheet 2
Listboxes and a range formatted in a matrix.

The first listbox lists categories the second lists styles for the selected
category. The matrix lists the product range for the selected style. Users
will then manually complete the matrix with an order.

My question is whether I should use listboxes on the worksheet or listboxes
on a userform?

It seems to provide more information at a glance to have the listboxes on
the worksheet. My problem is then how to cascade changes? A selection of a
category changes styles listed. A selection of a style changes the product
range listed.

Any example code appreciated or even just advice :-)

Many thanks
Jonathan