I have a field that needs to be populated with either the result of a formula or a manual input and am wondering whether I could do this with means of an input box?
I have a drop down list (validation) say in cell K11 with various percentage commission rates and the option of a fixed rate. the percentages are easy to deal with as I can put a formula in a cell (say J11) to work out the commision based on selling price and the rate selected, but if a fixed rate as been agreed I was wondering whether i could put VBA to check if Fixed is select to bring up a dialog box where a manual price can be entered which could populate a cell (AA11) which the if statement could then pick up. (as I do not want users overwriting the formula.)
any suggestions on the coding or a better solution would be appreciation
Many thanks
I have a drop down list (validation) say in cell K11 with various percentage commission rates and the option of a fixed rate. the percentages are easy to deal with as I can put a formula in a cell (say J11) to work out the commision based on selling price and the rate selected, but if a fixed rate as been agreed I was wondering whether i could put VBA to check if Fixed is select to bring up a dialog box where a manual price can be entered which could populate a cell (AA11) which the if statement could then pick up. (as I do not want users overwriting the formula.)
any suggestions on the coding or a better solution would be appreciation
Many thanks