Calling a subroutine when user selects value in Data Validation List

Hi,

I have found out how to call a macro when my user selects a yes/no value from my drop downlist. However, what I am worried about is the hard coding of "F3" in my code... If someone happens to insert a row above, my code will no longer work. The cell containing the drop down, F3, is called "geared_slew".

Question 1:
Is there another way of coding this functionality so that my code is not so "breakable"?

Question 2:
I don't want to call a macro. Rather I want to write a subroutine. How can I modify my code to rather call a subroutne called "setGearDataToNotApplicable" ?

SCREENSHOT1.jpg


Thanks
Michelle

Thank-you xlnitwit - solved!