Dependant? Data Validation

Hello mikerickson

Thank you for your quick reply.

If nothing is entered into A1 then nothing should happen. The purpose of this is to make sure that if a user enters any figure in A1 they are forced to make a selection from B1 so that C1 can be calculated.

I am not that advanced in my knowledge of excel and don't know how to implement the code that you have written.

I would really appreacicate your help by telling me if this is a macro, function or data validation.

I have attached a zipped file of a portion of the spreadsheet I am creating for you to see what I have done.

Many thanks