I have two option buttons on a user form named OptionButton1 & OptionButton2. When I select OptionButton1, I want the range name PBITtrigger to be equal to 1, and when I select OptionButton2, I want the range name PBITtrigger to be equal to 2. Can someone help with the code for this?
Thanks in advance.