Making cells "unavailable"
 

Hi,

I wanted to know if it is possible to make cells restricted based on values
selected from a drop-down list? For instance let's assume that cell A10 has
a list of 5 items. If item #1 is select then cells A2:A4 would be available
for input, if item #2 was selected, then cells B3, B4 would be available for
input. Can this be done? I know that it can be done via conditional
formatting but I need more than 3 "limit" conditional format.

Thanks

Making cells "unavailable"
 

IMHO, VBA is the only way to accomplish this.

--
Gary Brown

"TC" wrote:

Hi,

I wanted to know if it is possible to make cells restricted based on values
selected from a drop-down list? For instance let's assume that cell A10 has
a list of 5 items. If item #1 is select then cells A2:A4 would be available
for input, if item #2 was selected, then cells B3, B4 would be available for
input. Can this be done? I know that it can be done via conditional
formatting but I need more than 3 "limit" conditional format.

Thanks

Making cells "unavailable"
 

Gary,

thanks, I actually found a way to do it. I used the VLookup function on
the individual cells. So now if the user selects a certain product, only the
designated fields will appear on the form. Works like a charm.

"Gary L Brown" wrote:

IMHO, VBA is the only way to accomplish this.

--
Gary Brown

"TC" wrote:

Hi,

I wanted to know if it is possible to make cells restricted based on values
selected from a drop-down list? For instance let's assume that cell A10 has
a list of 5 items. If item #1 is select then cells A2:A4 would be available
for input, if item #2 was selected, then cells B3, B4 would be available for
input. Can this be done? I know that it can be done via conditional
formatting but I need more than 3 "limit" conditional format.

Thanks