Using macros to hide options in userform based off prior selections

Impossible to answer without seeing a copy of your workbook - see the yellow banner above for instructions how to upload.

The one thing that can be said is you 'crashed' excel because it went into an endless loop in the 2nd procedure you listed above. If OptionButton1 has a value of True then there is nothing to either exit the while loop or set OptionButton1 False so it just went around in circles...

Ok, here you go, the userform named modifiers is the only thing you need to see probably, most of the project is unfinished and unworking. But for a test select Endmill under tool type, and then Altima Plus needs to disappear under Coating, then I need Altima Plus to reappear after Endmill is deselected. Thanks though I figured as much in reference to the loop.

Sometimes it's harder to pose a question than actually answer it ...

Remove the Click Event for the option button and replace with Change event handler

Please Login or Register  to view this content.

Add any other controls that need hiding; however, I'd suggest setting the Enabled property to False instead - no awkward gaps in the list and it's obvious some can't be selected.

You'll need to repeat for other Tool types but there is a way to have just one procedure to handle all tool types, it just takes a little more coding ...

Hey, thanks I appreciate the speedy help. Sorry for the unclear posing of my question, I appreciate it though, very helpful!