software

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 quot;limitquot; conditional format.

Thanks

IMHO, VBA is the only way to accomplish this.

--
Gary Brown

quot;TCquot; wrote:

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

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.

quot;Gary L Brownquot; wrote:

gt; IMHO, VBA is the only way to accomplish this.
gt;
gt; --
gt; Gary Brown
gt;
gt; quot;TCquot; wrote:
gt;
gt; gt; Hi,
gt; gt;
gt; gt; I wanted to know if it is possible to make cells restricted based on values
gt; gt; selected from a drop-down list? For instance let's assume that cell A10 has
gt; gt; a list of 5 items. If item #1 is select then cells A2:A4 would be available
gt; gt; for input, if item #2 was selected, then cells B3, B4 would be available for
gt; gt; input. Can this be done? I know that it can be done via conditional
gt; gt; formatting but I need more than 3 quot;limitquot; conditional format.
gt; gt;
gt; gt; Thanks