SPND
09-04-2007, 07:10 AM
Hi,
This is my first post on this forum. Unfortunately i could not find a solution to my current problem in the exisiting posts although I am sure it is a easy one.
What I am trying to achieve is to get cell values change based on the selection of a drop down list. My drop downlist is in cell E6 and if the user selects option 1 in the drop down list then cell values in cell E13 to E23 should become 0 and not allow the user to change it without changing the drop down option.
If the user selects Option 2 in the drop down list, cell values in E13 to E23 should allow the user to input values ranging from 1 to 5 but not 0.
Hopefully I have been able to explain my problem clearly.
All help will be greatly appreciated.
Rgds,
SPND
This is my first post on this forum. Unfortunately i could not find a solution to my current problem in the exisiting posts although I am sure it is a easy one.
What I am trying to achieve is to get cell values change based on the selection of a drop down list. My drop downlist is in cell E6 and if the user selects option 1 in the drop down list then cell values in cell E13 to E23 should become 0 and not allow the user to change it without changing the drop down option.
If the user selects Option 2 in the drop down list, cell values in E13 to E23 should allow the user to input values ranging from 1 to 5 but not 0.
Hopefully I have been able to explain my problem clearly.
All help will be greatly appreciated.
Rgds,
SPND