I have one CheckBox on my user form, if it is checked I want the Value Yes
(or No if the CheckBox is not selected) to go into the active row column 2
(using something like rng(1, 2).Value = ???). My macro already sets the
current row as active, I just do not know how to code this.