Enable/Disable multitab pages based on matrix

[A[L]C]

Hi all,

I have a userform which pops up when the user clicks on a certain cell. The userform has a multipage with 13 pages, each of which has a different vechicle type (eg Bulk Tipper, Chipliner, Container etc)

Now depending which material type (Compost, Green waste, Food waste etc) is selected, I need to disable/enable pages based on a matrix. Currently the matrix is formatted as vehicle type in the column, and material type along the top, with an 'x' in the cell if that vehicle can carry that material.

What I need to do is depending on which material type is selected on that row (ActiveCell.Offset(0, -2).Value), I need the form to enable or disable the pages which have the name of the vehicle.

Can anyone point me in the right direction please?

Thanks a lot in advance!
Paul


edit: have uploaded the file. hopefully it will make more sense now!

[A[L]C]

Hi all,

Ok, so Im having a go at this. Unfortunately the For each part of my code is not working. Could someone give me a pointer please/

Please Login or Register  to view this content.

[snb]

Please Login or Register  to view this content.

[A[L]C]

Ok looks like Ive cracked it.

Please Login or Register  to view this content.

Nasty looking code though!