Unanswered: Force user action when populating cell
I am sure there is someone out there who knows how to do what I am hoping to achieve.
I am creating a spreadsheet for the staff to enter amounts into each month. I have attached spreadsheet file for you to see.
I would like help to achieve the following:
When a user enters an amount in a cell in the columns with the months above it (i.e. Rows 7 onwards and columns C, F & I etc), I want to force the user to select either “High”, “Med”, “Low” or “Firm” from the cell to the right of the cell they are populating, before they can continue.
For the user to select the High, Low, Med & Firm drop down cells I used the Data Validation List function.
I have set the grey cells with a formula that recognises the selected text and uses it to calculate a value from the user entered figure. Here is the formula I have used:
One suggestion, not directly related to your request, but to design to help you with your request. Normally (in western languages), people move from right to left, not the other way. It seems more logical to have the required cell prior to what you desire. Thus, change columns C and D and other pairs of columns).
Also, it seems that VBA code in a private module (worksheet event) would be the best approach.
old, slow, and confused
but at least I'm inconsistent!