Limiting possible responses on multiple User Forms

[Cerberus]

I am very new to VBA programming so forgive me if it seems basic but how
would I use true statements on multiple user forms to create a drill down
type procedure.

Basically I have 7 User Forms that ask questions on what type of list the
end user needs and I want to guide them to only valid responses. On the
first User Form all radio buttons are enabled. Based on the users choice the
second User Form will have some radio buttons enabled while others are grayed
out , do to me not having a list as of yet for that option. At this point I
know what to do, so I am fine there. The problem for me is, how I would make
it so when someone picks an option on the second User Form, User Form 3's
radio buttons will be enabled only when the first two choices are valid.

An example would be: The end user wants a 6 foot 2X4 made of pine

We have 1X1, 2X4, and 4X4 Oak in 3FT, 5FT, and 10FT lengths

We have 2X4 and 2X6 Pine in 4FT, 6FT, and 10FT lengths

And we have 2X6 and 4X4 Red Wood in 6FT lengths

So if the user picks 6FT on the first User Form1 (length) they should not
have 1X1 as an option on User Form2 (size) or Oak as an option on User Form3
(wood)

Now when the end user picks 2X4 on User Form2 (size) I need to have User
Form3 (wood) show only Pine as enabled

Thanks for any help in advance.

 

[Joel]

You need a table of your stock items. A good place would be on a hidden
worksheet. You can alos link the radio button to a worksheet cell. You
macro code wil need to determine from the entires on the worksheet which
responses are valid and which ones are not valid. Yoiu can use a worksheet
change event tirigger on the worksheet and when any of the linked items are
changed automatically go and update the userforms. the linked cells will
automatically change to either true or false when the radio butoon are
changed causingg a worksheet event to occur and should update the other
userforms.

 

[Cerberus]

Thank you Joel, I have something like that, that I have used before, but not
to that scale. Only 92 options instead of over 2000 options.