Disable option in list.

Dear sir/madam,

Is it possible to disable a option in a list?
For example:

In cell B1 the user can choose categories shares or bonds. In cell B2 the user can choose a valuation method. If the user choose bonds in cell B1, then I want the option Fair value disabled in the list of cell B2.

Is it possible to do that using macros?

Thanks in advance.

Kind regards,

Ka-Wai

Hi Ka-Wai,

You don't really need a macro for this. I think you can achieve this by some clever use of named ranges.
Assign a few named ranges below

Define the two names where 1 is the list of valuation methods, and 2 is a blank item.

Please Login or Register  to view this content.

Then define 2 more, 1 for the Category, and 2 is a named range with an IF statement, which is driven by Category to pick one or the other lists above.

Please Login or Register  to view this content.

The attached workbook demonstrates this concept.