Hello to all, First time user to this forum. I have some knowledge of VBA use in Accessnone in Excel.<o></o>
Here is what Im trying to accomplish:<o></o>
I have a column with cells set as a drop box selection (column C) . In said drop box if word CERFT is selected I would like the scrip to acknowledge selection, then reference cell B2value, then calculate with cell adjacent one columns to the right and enter that value but if CERFT not selected value can be entered.
in a sense: If C1 is "CERFT" then take value from B2 and times with D1 and enter value in E1 otherwise allow entry.
Cell: B2 value is .5
<tbody>
</tbody><o></o>
Here is what Im trying to accomplish:<o></o>
I have a column with cells set as a drop box selection (column C) . In said drop box if word CERFT is selected I would like the scrip to acknowledge selection, then reference cell B2value, then calculate with cell adjacent one columns to the right and enter that value but if CERFT not selected value can be entered.
in a sense: If C1 is "CERFT" then take value from B2 and times with D1 and enter value in E1 otherwise allow entry.
Cell: B2 value is .5
C | D | E | |
1 | CERFT (drop box) | 6.33 | 3.165 |
2 |
<tbody>
</tbody>