Dear all,

I have a sheet where I'd like to allow/disallow input of certain cells
based on the condition of another cell. For instance, if the value of
cell A1 is "Rectangular", I'd like to allow inputs for
length/width/height in cell A2, A3, and A4. If the value of A1 is
"Cylindrical", I want to disallow input in A2, A3, and A4, but allow
in A5 and A6 for diameter and depth.

Could you please recommend a strategy for processing such things?
In web programming you can conditionally disable or "gray out" input
field. Can such thing be implemented in Excel? If so, how do you do
it?

I'm fairly new to Excel and VBA (I actually started it yesterday :)
Your help will be greatly appreciated.

Thanks!
- B.R

Look in Excel in the Data menu, choose validation. You would need to write
formulas that supports your conditions. I don't think you can totally
disallow entry, but you could only accept something like Z%$ZX



--
Regards,
Tom Ogilvy

"Bob Rooney" wrote in message
om...
Dear all,

I have a sheet where I'd like to allow/disallow input of certain cells
based on the condition of another cell. For instance, if the value of
cell A1 is "Rectangular", I'd like to allow inputs for
length/width/height in cell A2, A3, and A4. If the value of A1 is
"Cylindrical", I want to disallow input in A2, A3, and A4, but allow
in A5 and A6 for diameter and depth.

Could you please recommend a strategy for processing such things?
In web programming you can conditionally disable or "gray out" input
field. Can such thing be implemented in Excel? If so, how do you do
it?

I'm fairly new to Excel and VBA (I actually started it yesterday :)
Your help will be greatly appreciated.

Thanks!
- B.R

Tom,

Could you explain what "Z%$ZX" means?
Thanks!

- B.R.

"Tom Ogilvy" wrote in message ...
Look in Excel in the Data menu, choose validation. You would need to write
formulas that supports your conditions. I don't think you can totally
disallow entry, but you could only accept something like Z%$ZX



--
Regards,
Tom Ogilvy

"Bob Rooney" wrote in message
om...
Dear all,

I have a sheet where I'd like to allow/disallow input of certain cells
based on the condition of another cell. For instance, if the value of
cell A1 is "Rectangular", I'd like to allow inputs for
length/width/height in cell A2, A3, and A4. If the value of A1 is
"Cylindrical", I want to disallow input in A2, A3, and A4, but allow
in A5 and A6 for diameter and depth.

Could you please recommend a strategy for processing such things?
In web programming you can conditionally disable or "gray out" input
field. Can such thing be implemented in Excel? If so, how do you do
it?

I'm fairly new to Excel and VBA (I actually started it yesterday :)
Your help will be greatly appreciated.

Thanks!
- B.R

It means the only entry you would accept is one that no one would ever
enter.

--
Regards,
Tom Ogilvy

"Bob Rooney" wrote in message
om...
Tom,

Could you explain what "Z%$ZX" means?
Thanks!

- B.R.

"Tom Ogilvy" wrote in message
...
Look in Excel in the Data menu, choose validation. You would need to
write
formulas that supports your conditions. I don't think you can totally
disallow entry, but you could only accept something like Z%$ZX



--
Regards,
Tom Ogilvy

"Bob Rooney" wrote in message
om...
Dear all,

I have a sheet where I'd like to allow/disallow input of certain cells
based on the condition of another cell. For instance, if the value of
cell A1 is "Rectangular", I'd like to allow inputs for
length/width/height in cell A2, A3, and A4. If the value of A1 is
"Cylindrical", I want to disallow input in A2, A3, and A4, but allow
in A5 and A6 for diameter and depth.

Could you please recommend a strategy for processing such things?
In web programming you can conditionally disable or "gray out" input
field. Can such thing be implemented in Excel? If so, how do you do
it?

I'm fairly new to Excel and VBA (I actually started it yesterday :)
Your help will be greatly appreciated.

Thanks!
- B.R